SOLUTION: Hi! You can email me this eurireunir14@gmail.com for the Excel file. I am trying to help my brother, who is having a hard time solving this.
PHSTAT solutions are required for p
Algebra ->
Probability-and-statistics
-> SOLUTION: Hi! You can email me this eurireunir14@gmail.com for the Excel file. I am trying to help my brother, who is having a hard time solving this.
PHSTAT solutions are required for p
Log On
Question 1198358: Hi! You can email me this eurireunir14@gmail.com for the Excel file. I am trying to help my brother, who is having a hard time solving this.
PHSTAT solutions are required for problems 4.
4. A sample of 60 students at the University of Florida provided responses to the question “What is your age?” and are shown in the Excel file student-survey.xls. Formulate hypotheses that can be used to determine whether the mean age of a UF student (variable AG) differs significantly from 25 years old. At a level of significance of 0.05, can the null hypothesis be rejected? Show the complete 8-step procedure with an opening statement of the parameter and use both the critical value approach and p-value approach.
the inputs to this calculator were as shown below:
the values were taken from the excel file you gave me.
here are the values from the column called AG (column C).
32
23
27
35
23
39
24
31
34
28
23
27
36
28
28
25
41
50
71
28
26
27
31
23
23
44
26
31
24
26
26
32
26
22
24
24
23
33
23
31
26
28
24
23
25
24
27
24
26
27
32
41
29
50
22
23
26
30
23
22
there were 60 values so your sample size was 60.
the degrees of freedom are equal to that minus 1 = 59
the software calculated the mean and the standard deviation and the standard error.
the results are shown below.
the two tailed p-value of the test was .0003.
since this is less than the two tailed criticl p-value of .05, the test results were considered significant.
the t-score was equal to 3.8080.
the critical t-score was calculated as plus or minus 2.00099.
since the test t-score was greater than this, the test results were considered significant.
your conclusion is that the mean age is probably not 25 years old, but something else, most likely higher.
i would imagine phstat would have similar input requirements.
i used my version of excel to get descriptive statistics for the sample and i used existing excel commands to get the t-score of the sample and the p-value of the swample.
the results are shown below:
the results are consistent with the online calculator results.
