Hi, I need help with this assignment please. It is for my Quant Analysis for Business class. Thank you in advance

AutoSave O Off) ICA 3 - Automobile Insurance Premiums - Excel Search yacouba konate YK) File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri v 11 General Conditional Formatting Insert 2 AY B U v A Format as Table Delete Analyze Sensitivity Paste Data A Cell Styles ~ Format Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity L16 X V A B C D E G H K M N O Automobile Insurance Premiums. Insure.com reports that the mean annual premium for Hypothesis test (One-Sample) T Dist (Summary Statistic) automobile insurance in the United States was $1365 in 2018. Being from Pennsylvania, you believe Sample Size Sample Mean automobile insurance is cheaper there and wish to develop statistical support for your opinion. A Sample Std Dev sample of 25 automobile insurance policies from the state of Pennsylvania showed a mean annual premium of $1302 with a standard deviation of s = $165. Hypothesized Value 1365 Level of significance 0.05 Co a. Develop a hypothesis test that can be used to determine whether the mean annual premium in Pennsylvania is lower than the national mean annual premium. Standard Error #DIV/O! 10 Test Statistic #DIV/O! 11 b. What is a point estimate of the difference between the mean annual premium in Pennsylvania Degrees of Freedom -1 12 and the national mean? 13 (Check if you need a one-tail or two tail test) 14 c. At a = .05, test for a significant difference. What is your conclusion? p-value (lower-tail) #DIV/O! 15 p-value (upper-tail) #DIV/O! 16 Ip-value (two-tail) #DIV/O! 17 Give your answers here. Use the table to the right to help you. 18 a. Critical Value (lower-tail) #NUM! 19 Critical Value upper-tail) #NUM! 20 b . Critical Value (two-tail) Use absolute value if test stat is positive #NUM! 21 22 C. 23 24 25 26 27 28 29 30 Sheet1 + D Ready 100% 2:13 AM Type here to search O 6/3/2021