Tutors pls help . Provide the formulas and everything
My student number 154988208
Second digit of my student number - 5
Fifth digit of my student number- 8
My version = 13
Above information will be need to solve the below excel question
Questions are of Hypothesis testing and Regression
Please solve this excel questions . Provide me with correct formulas and steps .
And there is one graph question please let me know how to solve it .
Please read the question carefully and provide me the correct answers . Its a excel file
tatistic: ue: lusion: Choose on: Choose p-value is lower thals p-value is higher that Choose Hypothesis testing RegressionDoes this store sell more laptops on Saturday, than on an average weekday? To test this, you have selected a sample of (40 + your version number ) Saturdays. Using this sample, you have calculated the average number of laptops sold on Saturdays. This sample showed the mean of 19.4 laptops and the sampe standard deviation was 4.7 laptops. Is there sufficient evidence that on Saturday the store sells more latops than on an average weekd The probability of Type I Error is set to (second digit of your student number )%. Post the solution below row 13 (use dropdowns where you see "Choose" and create your con HO: Choose (1 mark) H a: Choose Test statistic: (1 mark) p-value: (1 mark) Conclusion: Choose Reason: The store sells more The store does not s Choose Student info Hypothesis testing Regression3 It is known that Alpha electronics sells 18.1 laptops during a weekday (Monday-Friday). 4 Does this store sell more laptops on Saturday, than on an average weekday? 5 To test this, you have selected a sample of (40 + your version number ) Saturdays. 6 Using this sample, you have calculated the average number of laptops sold on Saturdays. 7 This sample showed the mean of 19.4 laptops and the sampe standard deviation was 4.7 laptops. 8 Is there sufficient evidence that on Saturday the store sells more latops than on an average weekday? The probability of Type | Error is set to (second digit of your student number )%. 10 11 Post the solution below row 13 (use dropdowns where you see "Choose" and create your computati 12 13 14 H_O: (1 mark) Choose 15 H a: Choose 16 H = 18.1 H 18.1 18 Test statistic: H 18.1 19 (1 mark) H # 18.1 20 Choose p-value: 21 22 (1 mark) Conclusion: Choose 23 Reason: Choose 24 25 14 4 1 Student info Hypothesis testing Regression Kea ReadyIt is known that Alpha electronics sells 18.]. laptops during a weekday [MondayFriday]. Does this store sell more laptops on Saturday, than on an average weekday? To test this, you have selected a sample of [40 + your version number] Saturdays. Using this sample, you have calculated the average number of laptops sold on Saturdays. This sample showed the mean of 19.4 laptops and the sampe standard deviation was 4.? laptops. Is there sufficient evidence that on Saturday the store sells more latops than on an average weekday? The probability of Type | Error is set to [second digit of your smdent number ]%. Post the solution below row 13 (use dropdowns where you see "Choose" and create your computations in cells 318 and 520 - keep all your Excel formulas there]: Conclusion: Choose Reason: Choose {1 mark) Below is the sample of 14 air flights showing the relationship between the length of turbulence during the flight and the average airline customer satisfaction score after the flight. Turbulence, minute-5 Satisfaction snare, out of 100 19,32 2 5,3 3,2 5 93,45 33,44 53,4 34,23 45,5 3,52 23,9 1 5,33 2 5,? 1 2,42 93,52 4,79 59,9 29,52 3 5,? 2,59 94,3 21,55 55,3 23,53 53,4 5,32 39,2 5 9,2 5 23,9 1. {1 mark} Use this data to find the slope and intercept of the estimated regression equation. 'I'our computation must go into cells B21 and B22: Slope: Intercept: 2. {1 mark} Predict the satisfaction score for [.10 + your version number] minutes of turbulence. 'I'our computation must go into cell 525: 3_{1 mark} Build the graph of the regression line belowI rowI 30. The graph must have the scatterplot and the regression line
