# Use the Student_Data.xls file which consists of 200 MBA students at Whatsamattu U. It includes variables regarding their age, gender, major, GPA, Bachelors GPA, course load, English speaking status, family, and weekly hours spent studying.

It is pretty common across most schools to find the grades at the MBA level divided between A’s and B’s. As such, you expect the mean GPA to be around 3.50. Using the sample of 200 MBA students, conduct a one-sample hypothesis test to determine if the mean GPA is different from 3.50. Use a .05 significance level.

Assume you read in the Whatsamatta U website that the average age of their MBA students is 45. Is this really true or have they failed to update this correctly? You think it is far less because there have been a lot more students going straight from their Bachelors to their Masters since the economy is so bad. You took a sample of 200 students (in the data file). Conduct a one-sample hypothesis test to determine if the mean age is less than 45. Use a .05 significance level.

Don't use plagiarized sources. Get Your Custom Essay on
Use the Student_Data.xls file which consists of 200 MBA students at Whatsamattu U. It includes variables regarding their age, gender, major, GPA, Bachelors GPA, course load, English speaking status, family, and weekly hours spent studying.
Just from \$13/Page

You have heard from idle chatter that most students don’t declare a major in their MBA programs. You took a sample of 200 students (in the data file). Conduct a one-sample hypothesis test to determine if the proportion without a major is greater than 50%. Use a .05 significance level.

Hyp Test Prop – One Sample
One Sample Hypothesis Test for the Proportion
Null Hypothesis
Level of Significance
Number of Successes
Sample Size
P =
0,5
0,05
40
100
This is an lower-tailed test since we are testing if the proportion is less than 50%.
The p-value of .0228 is less than .05, and so we reject the null hypothesis.
Thus we conclude that the proportion of homes made of brick is less than 50%.
Sample Proportion
0,40
(computed from Successes / Sample Size)
Z Test Statistic (Computed)
-2,00
Direction of Test
Lower Crit Value
Upper Crit Value
p -Value
Decision
Two-Tailed Test
H1: P 0.5
-1,9600
1,9600
0,0455
Reject the null hypothesis
Upper-Tail Test
H1: P > 0.5
n/a
1,6449
0,9772
Do not reject the null hypothesis
Lower-Tail Test
n/a
1.6449
0.0034
Lower-Tail Test