AutoSave . Off ) ASSIGNMENT 4 EXC... - Saved Search (Alt+Q) A Artur Asanaliev AA X Share Comments File Home Insert Page Layout Formulas Data Review View Developer Help Insert ~ 12 ~ A" A al Wrap Text General Ex AY O Calibri x Delete Paste LA $ ~ % 9 08 20 Conditional Format as Cell Sort & Find & Analyze E Merge & Center Formatting Table ~ Styles v Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis C23 X Choose D E F G H K M N P Q R S 1 Use sheet "Student Info" for your vesrion number. 2 3 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 I 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 computations in cells B18 and B20 - keep all your Excel formulas there): 12 13 14 (1 mark) H_O: Choose 15 H_a: Choose 16 17 18 Test statistic: 19 (1 mark) 20 p-value: 21 22 (1 mark) Conclusion: Choose 23 Reason: Choose 24 25 26 Activate Windows 27 Go to Settings to activate Windows. Student info Hypothesis testing Regression + : 4 D + 74% Ready Accessibility: Good to go 1:02 AM 0 O X 5.C Cloudy ~ D (7 .)) ENG 2022-04-19ASSIGNMENT 4 EXC... A Artur Asanaliev AA X AutoSave . Off ) Search (Alt+Q) Insert Page Layout Formulas Data Review View Developer Help Share Comments File Home Insert Calibri ~ 12 ~ A" A al Wrap Text General Ex AY O Ex Delete LA Sort & Find & Analyze Paste Conditional Format as Cell E Merge & Center ~ $ ~ % 9 08 20 Formatting Table ~ Styles v Format Filter ~ Select v Data Font Alignment Number Styles Cells Editing Analysis Clipboard B23 X v fx C D E F G H K M N O P Q R S A 1 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, minutes Satisfaction score, out of 100 19.82 76. 3.75 98.45 30.44 60.4 34.23 45.5 3.57 78.9 16.88 75.7 12.42 93.67 11 4.79 59.9 12 20.62 35.7 13 2.69 94.8 14 21.56 65.3 15 23.68 58.4 16 5.82 89.76 17 9.75 78.9 18 19 1. (1 mark) Use this data to find the slope and intercept of the estimated regression equation. Your computation must go into cells B21 and B22: 20 21 Slope: 22 Intercept 23 24 2. (1 mark) Predict the satisfaction score for (10 + your version number ) minutes of turbulence. Your computation must go into cell B26: 25 26 Satisfaction score: 27 28 3. (1 mark) Build the graph of the regression line below row 30. The graph must have the scatterplot and the regression line: 29 30 Activate Windows 31 Go to Settings to activate Windows Student info Hypothesis testing Regression + O J -- + 66% Ready EO Accessibility: Good to go 1:05 AM O O X 5.C Cloudy ~ D (7 41) ENG 2022-04-19AutoSave . Off ) ASSIGNMENT 4 EXC... Search (Alt+Q) A Artur Asanaliev AA X File Home Insert Page Layout Formulas Data Review View Developer Help Share Comments Insert Calibri ~ 12 ~ A" A ab Wrap Text General X Delete Paste LA Sort & Find & Analyze BIUVV MA v E Merge & Center $ ~ % 9 08 40 Conditional Format as Cell Formatting Table Styles v [Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis B1 X v fx A B C D E F G H 1 Last name 2 First name 3 Student number 4 Second digit of the student number 5 Fifth digit of the student number 6 Your version: 8 9 10 11 12 13 14 Activate Windows Student info Hypothesis testing Regression + Go to Settings to activate Windows. D Ready EO Accessibility: Good to go - + 139% O 1:05 AM X 5.C Cloudy ~ D (7 1) ENG 2022-04-19