I need your help with the data attached. Can you kindly help me compute the problems found in the main attached?

The mean price for used cars is $10,511. A manager of a Kansas City used car dealership reviewed a sample of 50 recent used car sales at the dealership in an attempt to determine whether the population mean price for used cars at this particular dealership differed from the national mean. The prices for the sample of 50 cars are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Open spreadsheet a. Formulate the hypotheses that can be used to determine whether a difference exists in the mean price for used cars at the dealership. Ho :p. V $10,511 Ha :p V $10,511 b. What are the test statistic and the p-value? Do not round intermediate calculations. t C] (to 3 decimals) pvalue C] (to 4 decimals) c. At a = 0.01, what is your conclusion? the null hypothesis. We have evidence to conclude that the population mean price at this dealership differs from the national mean price of $10,511. Excel template - Saved v 9 s File Home Insert Draw Page Layout Formulas Data V Arial 10 B A D4 v X V fx C D E F A B Sale Price Formulas 7636 Sample Size 50 8814 #N/A 9894 Sample Mean (to the whole number) 7057 Sample Standard Deviation (to the whole number) #N/A 11058 11843 9350 Hypothesized Mean 10511 11431 9097 Test Statistic (3 decimals) #N/A 11 6883 #N/A 12 10795 Degrees of Freedom 13 12726 14 11459 p-value (4 decimals) #N/A 15 7214 16 10304 Level of Significance (Alpha) 0.01 17 9365 #N/A 18 7716 Reject Null Hypothesis? 19 9164 Can conclude the population mean price at this 20 8059 dealership differs from the national mean price? #N/A 21 8725 22 11087 23 6959 24 7558 25 12030 26 10707 27 3663 28 7339 29 11939 30 10248 31 10855 32 6408 33 7559 34 6587 35 12757 36 13002 37 8955 38 10675 39 12846 40 7415 41 9380 42 9453 43 7284 44 8603 45 11513 46 11208 47 12244 48 7173 49 11093 50 8400 51 10735