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

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.

Answer by Theo(13342) (Show Source): You can put this solution on YOUR website!
i was not abl to do it through phstat, but i was able to solve it using an online statistical calculator.

the calculator i used is at https://www.graphpad.com/quickcalcs/oneSampleT1/?Format=C

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.

RELATED QUESTIONS
Hi! You can email me this eurireunir14@gmail.com for the Excel file. I am trying to help... (answered by CPhill)

I am trying to come up with a quadratic equation that will have 2 solutions: 0 &... (answered by jim_thompson5910)

I am having a very hard time trying to figure this out. Can you please help me? Find... (answered by Fombitz)

x-8(3.14)=3.14 This is what I have gotten for the equation above. Can you please see if (answered by stanbon)

I am having a difficult time trying to figure out this equation: A rectangle has a width (answered by ewatrrr)

i am an 8 grader who is trying very hard with my work i really do need your help... (answered by mathemanic)

I notice that this question has already been asked but I am still having a hard time... (answered by Maggy)

Needing help with American School Algebra 1 my last three exams 9 10 and 11 can trade... (answered by berrymorerachel)

Graph the inequality. x < �2 Someone please help me with this I have no idea how to do (answered by jim_thompson5910)