Question

Data Analysis is designed to build a strong foundation for development of statistical literacy and statistical thinking. Both are essential for business success and further studies in business. Recent research showed that “On average for 15-year-old Australian students, females achieved at a significantly lower level than male students (in mathematics)” (p.2, Buckley 2016) 1 . However, there is also research evidence that “Despite the stereotype that boys do better in math and science, girls have made higher grades than boys throughout their school years for nearly a century” (APA 2014)2 . The Head of School funds a research study to investigate gender differences in, and other factors influencing, exam performance in Data Analysis. Data are collected on the following variables from a sample of 694 students enrolled in the unit in 2015.

• Final exam mark (out of 60)3

• Gender • Degree Type

• Country of Citizenship

• Lecture Attendance

You are appointed as the research analyst to examine the data and report key findings to the project officer. The dataset is contained in the file: Exam Results.xlsx. The project officer sets the following tasks to guide your investigation.

Task 1 (t-tests) 1. In 2014 the average final exam mark was 29.6 out of 60. You want to test at 5% if the average exam mark in 2015 has decreased. (Include all six steps of hypothesis testing.)

2. In order to investigate differences in exam performance you conduct separate two-sample t-tests. (Conduct your tests at α = 5%.)

(a) Considering the whole sample of 694 students, test if there is a difference in the average exam performance between female and male students.

(b) Test if there is a difference in the average exam performance between single degree and double degree students.

(c) Considering both single and double-degree students, test if there is any gender difference in exam performance.

(d) Present your findings in parts (a), (b) and (c) using appropriate graph(s), and discuss any important observation(s).

You plan to develop regression models to investigate the factors that influence students’ final exam performance. However, you are not sure how to handle the country of citizenship variable. After further discussion and based on international standardised tests, you and your project officer believe that East Asian students tend to have stronger maths background, and decide to create three categories: Australian, East Asian and others, to recode this variable. You also agree that East Asian students should include those from China, Japan, Korea, Taiwan and South East Asian countries, and that students from New Zealand are not classified as Australian.

You conduct several regressions as well as a stepwise regression according to the following procedure:

Step 1: All variables independently (SLR) with the dependent variable

Step 2: Gender and Degree Type (MLR)

Step 3: Gender, Degree Type and Country of Citizenship (MLR)

Step 4: Gender, Degree Type, Country of Citizenship and Lecture Attendance (MLR)

(a) Present the regression output for each of the regressions in a table noting the coefficients, assessing the adequacy of the model and the p-value of the model and the coefficients individually.

(b) Based on the regression output obtained in Step 4, answer the following questions: • Which models are significant? • For the model defined as Step 4: interpret the regression coefficients and comment on their statistical significance. Is this a useful model in being able to interpret a students mark in the final examination?

Country of Citizenship Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Korea, (Sth) Republic Of Australia Australia Australia Australia Australia Australia Australia Lecture Attendance 10 Gender Degree Type Double Single Single Single Single Single Single Single Single Single Single Single Single Double Single Single Single Single Double Single Double Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single EXAM MARK 25 32 25.5 22.5 20 21.5 20.5 32.5 41.5 18.5 38.5 52 30 27.5 15 21.5 20.5 12.5 10 33.5 27.5 35.5 16 17.5 16 24.5 35.5 18.5Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia China Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Single Double Double Single Double 5 24.5 30.5 Single Double 39.5 15.5 5 Double Single Double Double 29.5 Single Single 0 Single Double Double Double Single Double 5 Double Double 5 Single Single Single Double Single Double 5Australia Vietnanm Australia Australia Australia 4 2 Single Double Single Australia Taiwan Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Indonesia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia 3 Double Double Double Single 0 Double 5 Double Double Double 3 Single 5 6 2 Single 2 Double Double Double Single 6 Double 2 DoubleAustralia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia New Zealand Australia Australia Australia Australia Australia Australia Double Double Double 2 4 Double 8 Double 4 9 3 Double Double 1 Double 4 4 Double 8 Hong Kong Australia Australia New Zealand Australia Australia Australia 1 1 Double 3China Australia India Australia Australia Australia Australia Australia Hong Kong China Portugal United States of America Hong Kong India Taiwan Vietnam Australia China Malaysia Australia Australia China China Australia Australia Australia China Australia Australia Australia Australia Australia Australia Australia Papua New Guinea China Australia China Australia Single Single Single Single Single Double Single Single Single Single Single Single Single Single Single Single Double Single Single Single Single Single Single Double Double Single Single Double Single Double Single Double Double Single Single Single Single Double Double 17.5 24.5 17.5 12.5 10 18.5 10 24.5 42.5 19.5 27.5 10 22.5 11.5 29.5 31.5 54.5 24.5 31.5 22.5 46.5 57.5 33.5 10 10 15.5 28 21.5 36.5Australia Australia Australia Australia Australia Australia Australia Philippines Australia China Taiwan China Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia New Zealand Australia Australia Australia Single Single Double Single Single Single Single Double Double Single Single Single Single Single Single Single Single Single Single Double Double Double Single Double Single Single Double Double Single Single Single Double Double Double Single Double Single Double Double 38 12.5 20 39.5 25 31 42.5 18 25.5 28 19 35.5 18.5 27.5 30.5 24.5 45.5 37.5 10 16 28 10 48.5 23.5 43 27 12 14.5 35 10Australia Australia Australia Australia Australia Australia 3 Single 1 5 1 1 Australia Australia Australia Taiwan Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia 0 Double Double Double Double 3 5 Double Double Double Double Double 2 Double 8 Double Double Double 1 Double Double Double Double Double Double Double 2Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Papua New Guinea Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Double Double Double Double Double Double Double Single Double Double Double Double Double Double Double Double Single Double Double Double Double Single Single Double Double Double Double Double Double Single Double Double Double Double Double Double Double Double Double 19.5 52.5 29.5 35.5 21.5 25.5 35.5 10 53.5 27 39.5 23.5 18.5 38 21.5 24.5 47.5 41.5 18.5 19.5 35.5 28.5 16.5 28.5Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia China Papua New Guinea China Hong Kong Singapore China China Hong Kong China Double Single Single Single Double Double Double Double Double Double Double Single Single Single Single Double Double Double Double Double Single Double Double Double Double Double Single Double Double Double Single Single Single Single Single Single Single Single Single 26.5 17 57 27 20.5 39.5 51.5 53 26.5 10 10 26.5 36.5 20 24.5 25.5 19.5 25.5 10 21.5 25.5 19.5 18.5 35 29 10 10 30 44.5 18.5 10 33.5 10Single Taiwan China Australia Australia Australia Australia Australia Hong Kong Saudi Arabia Singapore Single Double 2 Double Single 2 0 Single Single Single Single Norway Malaysia Malaysia China 5 Single Single 3 Single Single China 1 China China China China Saudi Arabia Malaysia France China Australia Australia Australia Australia Hong Kong Saudi Arabia China Hong Kong China Australia Australia Australia Single Single 2 3 5 3 0 Single Single Single 2 Single Single Single Single Single Single 2 2 5Single Single Single Single Single Australia Australia Liberia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Korea, (Sth) Republic Of Hong Kong Hong Kong Azerbaijan China Australia Norway China Korea, (Sth) Republic Of Saudi Arabia China Philippines Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia 10 26.5 28.5 Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Double Single Double Single Double Single Single Single Double Double Single Single Single Double 26.5 22.5 17.5 20.5 14.5 32 11.5 33.5 37 26 10 23 33.5 21.5 36.5 14.5 36 44.5 28.5 18 10.5 10 38.5 54.5 25 10 10 32.5 25.5Australia Australia Australia Australia Australia Australia Australia Australia Australia Korea, (Sth) Republic Of New Zealand Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia New Zealand Australia Australia Australia Nicaragua Australia Australia Australia Australia Australia Australia Australia Single Single Double Single Single Single Double Single Single Single Single Single Single Single Single Double Double Single Single Single Double Double Single Single Double Single Single Single Single Single Single Single Single Single Double Single Single Single Single 19.5 34.5 49.5 32.5 10 10 28 22.5 43.5 25 39.5 25.5 38 11.5 23.5 35.5 35.5 8.5 10 32.5 46 30.5 23.5 21.5 22.5 37 21.5 31.5 47.5 17.5Single Single Single Single Double Double 28.5 Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia 32.5 46.5 56.5 Single Double Single Single Single Double Double Single Single Single Double Double Double Double Single Double Single Single Single Double Single Double Single Double Single Double Single Single Double Double Double Single 15.5 38 19.5 35.5 19.5 28.5 21 24.5 41.5 52 18.5 38.5 10 23.5 20.5 26.5 54.5 10 4 26.5 33.5 32.5 20.5Australia Australia Double Australia Australia Australia Australia Australia Australia Australia Australia New Zealand Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia 9 Double Double Double Double 3 2 2 3 2 3 5 9 Double 3 Double Double 0 Double Double Double 2 0 9 Double Australia Australia Australia Australia Australia Australia DoubleAustralia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Canada Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Bangladesh Australia Australia Australia Australia Australia Australia Australia Double 3 Double Double Double Double 2 0 5 Double Double Double Double 5 5 Double 1 Double Double Double 1 Double Double Double Double Double Single 5 1 518.5 Philippines Australia Australia Australia Australia Australia Australia Single Single Single Single 16 33.5 30 Double Double Single Double Single Single Single Single Single Single Single Single Single Single Double Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Papua New Guinea Australia Hong Kong Malaysia 33.5 26.5 Australia 20 South Sudan New Zealand Australia Australia Australia Australia Australia China Malaysia Korea, (Sth) Republic Of China Japan England Germany China Australia Australia Australia Australia Australia Australia 28.5 16.5 50 24.5 34.5 52.5 20.5 36.5 31.5 52.5 43.5 38.5 37.5 55.5 17 44.5 32.5 India China Japan Singapore Malaysia Sri Lanka Single Single Single Single Single 49 29.5 37Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Single Double Single Single Single Single Single Single Single Single 50.5 32.5 25.5 38 36.5 19.5 32.5 16.5 28.5 Korea, (Sth) Republic Of Hong Kong Taiwan Malaysia Australia Australia Australia Australia Australia Australia Australia New Zealand Australia Australia Australia Australia Australia Brazil Australia Korea, (Sth) Republic Of Australia Australia Australia Australia Australia Australia New Zealand Australia Australia Australia China China 10 10 21.5 48 20 18.5 57 31 44.5 25 10 10 18.5 14.5 23 29.5 12.5 17.5 22.5 21.5 23 15.5 20 59 10 10 10 10

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
Data Analysis is designed to build a strong foundation for development of statistical literacy and statistical...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Data Analysis is designed to build a strong foundation for development of statistical literacy and statistical...

    Data Analysis is designed to build a strong foundation for development of statistical literacy and statistical thinking. Both are essential for business success and further studies in business. Recent research showed that “On average for 15-year-old Australian students, females achieved at a significantly lower level than male students (in mathematics)” (p.2, Buckley 2016)1 . However, there is also research evidence that “Despite the stereotype that boys do better in math and science, girls have made higher grades than boys throughout...

  • Data Analysis is designed to build a strong foundation for development of statistical literacy and statistical...

    Data Analysis is designed to build a strong foundation for development of statistical literacy and statistical thinking. Both are essential for business success and further studies in business. Recent research showed that “On average for 15-year-old Australian students, females achieved at a significantly lower level than male students (in mathematics)” (p.2, Buckley 2016)1 . However, there is also research evidence that “Despite the stereotype that boys do better in math and science, girls have made higher grades than boys throughout...

  • This is a MATLAB question need details step by step Class15_voltage.txt 2070.106649    1959.461152 1854.729565 1755.595796...

    This is a MATLAB question need details step by step Class15_voltage.txt 2070.106649    1959.461152 1854.729565 1755.595796 1661.760645 1572.940905 1488.868508 1409.289711 1333.964335 1262.665039 1195.176631 1131.295423 1070.828614 1013.593705 959.4179554 908.137855 859.5986337 813.6537939 770.1646679 729 690.0355497 653.1537172 618.2431883 585.1985985 553.9202148 524.313635 496.2895026 469.7632369 444.6547784 420.8883462 398.3922104 377.0984745 356.9428712 337.8645684 319.8059851 302.7126183 286.5328779 271.2179313 256.721556 243 230.0118499 217.7179057 206.0810628 195.0661995 184.6400716 174.7712117 165.4298342 156.5877456 148.2182595 140.2961154 132.7974035 125.6994915 118.9809571 112.6215228 106.601995 100.9042061 95.5109593 90.4059771 85.57385199 81 76.67061663 72.57263525 68.69368759 65.0220665 61.54669054 58.25707056 55.14327806 52.19591521...

  • 22 Use data_Americas. Plot year vs gdpPercap. Scale gdpPercap by log10. Color the data by country....

    22 Use data_Americas. Plot year vs gdpPercap. Scale gdpPercap by log10. Color the data by country. 23 Use data_Americas. Plot year vs gdpPercap. Scale gdpPercap by log10. Color the data by country and size by pop. Looking for the answers in R command codes. 1952 1957 1962 1967 1972 1977 1982 1987 1992 1997 2002 2007 142 142 142 142 142 142 142 142 142 142 142 142 > table(gapminder$country) Afghanistan Albania Algeria 12 12 12 Angola Argentina Australia 12...

  • DATA: # happy2.py import csv def main(): happy_dict = make_happy_dict() print_sorted_dictionary(happy_dict) def make_happy_dict(): filename = "happiness.csv"...

    DATA: # happy2.py import csv def main(): happy_dict = make_happy_dict() print_sorted_dictionary(happy_dict) def make_happy_dict(): filename = "happiness.csv" happy_dict={} with open(filename, 'r') as infile: csv_happy = csv.reader(infile) infile.readline() for line in csv_happy: happy_dict[line[0]] = line[2]       return happy_dict def lookup_happiness_by_country(happy_dict): return def print_sorted_dictionary(D): if type(D) != type({}): print("Dictionary not found") return print("Contents of dictionary sorted by key.") print("Key","Value") for key in sorted(D.keys()): print(key, D[key]) main() "happines.csv" Country,Year of Estimate,Happiness Index Afghanistan,2018,2.694303274 Albania,2018,5.004402637 Algeria,2018,5.043086052 Angola,2014,3.794837952 Argentina,2018,5.792796612 Armenia,2018,5.062448502 Australia,2018,7.17699337 Austria,2018,7.396001816 Azerbaijan,2018,5.167995453 Bahrain,2017,6.227320671 Bangladesh,2018,4.499217033...

  • Please Show all work . Use attached Data and graph to answer questions Titration of Acetic...

    Please Show all work . Use attached Data and graph to answer questions Titration of Acetic Acid: 0. IM 1) Check to make sure that the volume on If it does not read 0.00 mL, adjust it to do so before you proceed any further. your sodium hydroxide buret reads 0.00 mL 2) Use the buret that is located near the acetic acid container to dispense 25.00 mL of acetic acid solution into a clean dry 100 mL beaker. Record...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT