Please show how you solve for the p-value manually (without excel) and please show work!!

4. 3/11 Points DETAILS PREVIOUS ANSWERS ASWESDE 9.L.027 MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER You may need to use the appropriate appendiabile or technology to answer this question According to the Vivino website suppose the mean price for bottle of red wine tore or on the Vivine Rating System 24. A New England-based magazine wants to determine Fred wines of the same quality are less expensive in Providence, and its collected price for randomly selected red wines The mean and standard deviation for this sample are $30.55 and 512, respectively iar alty from wine or throughout Providence (a) Develop appropriate hypothese for at to determine whether the sample data oport the conclusion that the vidence for the red wine to her on the Vivino Rating System is less than the population mean of 532.48 (finter for as needed) Mo 32.48 32.48 ch) Using the sample from the bottles, what is the test statistic found your answer to three decimal places) Using the sample from the bottles, what is the value Cound your answer to four decimales D-value - 0.7412 te) At = 0.05, what is your conclusion De not reject Mo. We can condude that the price in Providence for a bottle of red wine that com 40 or higher on the wino Rating System is less than the population mean of 532.48 Reject Wo. We cannot conclude that the price in Providence for a bottle of red wine that cores 4.0 or higher on the Vivino Rating System is less than the population mean of $32.48 Do not reject He we cannot conclude that the price in Providence for a bottle of red wine that is righer on the Vivino Rating System is less than the population mean of $3246 Reject Hy we can conclude that the price in Providence for bottle of red wine that stores 4.0 or hight on the Vivino Rating System is less than the population mean of 532.43