logo

Statistics - Desklib Online Library for Study Material

Data analysis assignment for the Statistics for Business course in the Autumn Session 2022. Students are required to use Excel for calculations and statistical analyses.

8 Pages726 Words67 Views
   

Added on  2023-06-10

About This Document

This article discusses three questions related to statistics. The first question tests whether the average GPA is different for females compared to males. The second question tests whether a student owning an iPad is dependent on how often they exercise. The third question concludes whether a linear relationship exists between work hours and distance from campus. The article also includes a list of references.

Statistics - Desklib Online Library for Study Material

Data analysis assignment for the Statistics for Business course in the Autumn Session 2022. Students are required to use Excel for calculations and statistical analyses.

   Added on 2023-06-10

ShareRelated Documents
Statistics
Statistics - Desklib Online Library for Study Material_1
Contents
Question 1........................................................................................................................................3
Test, at the 5% level of significance, whether the average GPA is different for females
compared to males.......................................................................................................................3
Question 2........................................................................................................................................3
Test, at the 5% level of significance, whether a student owning an Ipad is dependent to how
often they exercise?.....................................................................................................................3
Question 3........................................................................................................................................5
Can we conclude, at a 5% level of significance, that a linear relationship exists between the
Work Hours (y) and Distance (x) a person lives from campus?..................................................5
REFERENCES................................................................................................................................7
Statistics - Desklib Online Library for Study Material_2
Question 1
Test, at the 5% level of significance, whether the average GPA is different for females compared
to males.
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.074377
R Square 0.005532
Adjusted R
Square -0.01191
Standard
Error 1.537131
Observation
s 59
ANOVA
df SS MS F
Significan
ce F
Regression 1 0.749176
0.74917
6
0.31707
5 0.575579
Residual 57 134.6779
2.36277
1
Total 58 135.4271
Coefficien
ts
Standard
Error t Stat P-value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Intercept 3.862069 0.285438
13.5303
2
1.91E-
19 3.290489
4.43364
9
3.29048
9
4.43364
9
1 -0.2254 0.400292
-
0.56309
0.57557
9 -1.02697
0.57616
9
-
1.02697
0.57616
9
As in the above test of regression the significance value taken is 0.05, and the results which show
is 0.57. it means there is a significant level of difference in the average of GPA between 0 and 1
variables which are represented by male and female.
Question 2
Test, at the 5% level of significance, whether a student owning an Ipad is dependent to how often
they exercise?
Statistics - Desklib Online Library for Study Material_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Anova Assignment | Answers
|22
|2126
|25

SEO Suggestions for Desklib Online Library
|4
|530
|447

Analysis of Click Sales Data
|11
|1213
|79

Regression Analysis of Relationship between Annual Income and Credit Card Charges
|7
|1017
|404

Business Statistics
|5
|454
|43

Quantitative Analysis 1
|15
|1568
|2