Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use Sheet 3 of the Excel file to answer the following questions. A school administrator believes that the mean class GPAs for a given course
Use Sheet 3 of the Excel file to answer the following questions. A school administrator believes that the mean class GPAs for a given course are higher than the preferred mean of 2.75 at a significance level of 0.05, and checks a randomly chosen sample of 50 classes. Create a histogram, and calculate x, the t-statistic, and the p-value. From the histogram, can normality be assumed? Pick v = Ex: 1.234 + = p = Since the p-value is Pick v than the significance level 0.05, the null hypothesis Pick V Pick V evidence exists that the mean GPA is greater than 2.75.AutoSave OFF Home Insert Draw Page Layout Formulas Data Calibri (Body) 11 v A A Paste BI UV v SV Av E18 X V fx A B C D E F G 2.59 2.43 3 2.96 2.80 5 2.94 6 3.07 2.65 8 2.79 9 2.61 10 2.90 11 3.14 12 2.78 13 2.50 14 2.78 15 2.52 16 2.60 17 2.86 18 2.88 19 2.78 20 3.09 21 2.82 22 2.72 23 2.98 24 2.68 25 2.87 26 2.86 Sheet1 Sheet2 Sheet3 Sheet4 She ReadAutoSave OFF Home Insert Draw Page Layout Formu X Calibri (Body) V 11 v A Paste BIUV V LV A E18 X v fx A B C D E F 27 2.78 28 2.73 29 2.62 30 2.77 31 2.90 32 3.02 33 2.73 34 2.87 35 2.63 36 2.98 37 2.52 38 2.81 39 2.91 40 2.71 41 3.07 42 2.89 43 2.93 44 2.64 45 2.94 46 2.81 47 2.85 48 2.89 49 2.79 50 2.86 51 52 Sheet1 Sheet2 Sheet3 Sh Ready
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started