this is a statistics assignment. the salary is used for it

MGSC2207 Summer Session I 2021 1) [16 marks] An experiment was designed to investigate the perception of corporate ethical values among individuals specializing in marketing (higher scores indicated higher ethical values). The scores (6 per group) were gathered on three groups: Marketing Managers, Marketing Research and Advertising. 3) [4] Complete the ANOVA table below. Use a signicance level of 0.05. ANOVA Source of Variation SS df MS F Pvalue F crit Between Groups Within Groups 0.5 Total 14.5 b) [4] Test for signicant differences in perception among the three groups. Page 2 of 14 MGSC2207 Summer Session I 2021 c) [6]Use 0.05 level of significance and the additional information below to conduct a Fisher's LSD procedure to determine where the differences occur. Mkt Mgrs (Grp1) Mkt Res (Grp 2) Adv (Grp 3) mean 4.5 (c) [2] Minitab results for a Fisher's LSD are provided. Are the results consistent with your findings? Explain. Grouping Information Using the Fisher LSD Method and 95% Confidence Factor N Mean Grouping Advertising 6 6.000 A Marketing Managers 6 5.000 Marketing Research 6 4.500 Means that do not share a letter are significantly different. Page 3 of 14MGSC2207 Summer Session I 2021 2. [18 marks] A local chapter of sales professionals in the Greater Toronto Area wanted to explore the relationship (if any) between years of experience and salary for individuals employed in inside and outside sales positions. On the survey, respondents were asked to indicate one of three levels of experience: Low (05 years, Medium (615 years) and High (16 years or more. The data set of 120 observations is in the Excel le Salary. a) [12] Use Excel to obtain a two-way analysis of variance of the data. Test for any signicant differences due to position, for level of experience, and for any interaction between position and experience. Use a 0.05 level each time and explain your findings in one or two sentences. Page 4 of 14 MGSC2207 Summer Session I 2021 b) [3] Repeat the analysis in Minitab. In order to use the ANOVA procedure in Minitab, you must rst convert the data to the correct format: All the data must be in one column, with the information about experience in a second column and the position in a third. The easiest way to do that is to \"Stack\" the columns: Select Data > Stack > Columns. Select the three columns \"Low\MGSC2207 Summer Session I 2021 c) [3] Obtain grouped boxplots for each combination of experience and position. What do you see? (Explain in a short paragraph.) (In Minitab, select Graph > Boxplots > \"With groups\". Click OK, then select the salary data into the Graph Window and select as grouping variables the new position column you created earlier and then the experience column. Page 6 of 14 MGSC2207 Summer Session I 2021 3. [26 marks] A supermarket chain wanted to know whether there was any relationship between the price (in dollars) set by the chain for its inhouse brand of coffee and demand (measured in pounds of coffee). Eight stores in the chain that had nearly equal past histories of demand for this brand of coffee were used in the study. Eight different prices were randomly assigned to the stores (one price per store) and an identical ad campaign was run in each market. The number of pounds of coffee sold during the following week was recorded for each store. Answer all parts of this question using hand calculations except where indicated. 2(price) = 26.8 2(demand) = 690 2(price) * (demand) = 2,285.8 Z(price)2 = 90.2 Z(demand)2 = 61,138 (1) [8 marks] Use this space to do the basic (hand) calculations, 9?, 37, SS x, SS y, 53:63), SSE, d f & Se, which may be used in the following steps of analysis. Page 7 of 14 MGSC2207 Summer Session I 2021 (2) [6 marks] Is there a significant correlation between price and demand? Use a = 0.05. (3) [4 marks] What do the regression coefficients (bo and bi) in the regression equation mean? Explain what each of the 2 coefficients mean, in context. Show your hand calculations for each. Page 8 of 14MGSC2207 Summer Session I 2021 (4) [2 marks] What is the percentage of total variation in demand that is n_0t explained by the prediction equation (i.e., what is the error variation here)? Show your calculations. (5) [4 marks] Suppose the owner of the supermarket chain wants to know what the predicted mean demand is when the price is set at $3.40. Construct a 95% condence interval for the predicted mean demand of all stores offering their coffee at $3.40 per pound? Explain to the owner what it means. Page 9 of 14 MGSC2207 Summer Session I 2021 (6) [2 marks] Compute a 95% confidence interval for the demand at a randomly selected store where the price is set at $3.40. Why is this confidence interval wider than the interval you computed in (5)? Page 10 of 14MGSC2207 Summer Session I 2021 4. [24] A random sample of 30 second year business students at a university were polled by a researcher attempting to establish a relationship between hours of study in the week immediately preceding a major midterm and the marks received on the exam. a) [4] Complete the following ANOVA resulting from analysing the data. ANOVA df SS MS F p-value Regression 4044.5 67.77 Residual Total b) [3] Use the output below to determine if there is a relationship between study time and exam score. If there is a relationship, describe it. Standard Coefficients Error Intercept 31.58 5.99 Hours 2.55 .310 Page 11 of 14MGSC2207 Summer Session I 2021 c) [3] Use the same output given in part b to test whether the intercept in the model equals zero. Does the result make sense? Explain. d) [2] Calculate the coefficient of determination and interpret your result. Show your calculations. e) [2] Calculate the standard error of the estimate. Show your calculations. Page 12 of 14MGSC2207 Summer Session I 2021 f) [4] If the mean of the hours of study is 19 and the variance for the hours of study is 23.58333, determine the 95% CI for students who spend an average of 18 hours studying for the exam. Include a statement. (The hours of study in the original data set ranged from 8 to 25 hours.) g) [2] Suppose that a rst-year student wishes to use the results of the analysis to determine their performance in the following year on a similar exam and that this student would typically study 18 hours for such an exam. Develop a 95% PI for the student. Page 13 of 14 MGSC2207 Summer Session I 2021 h) [4] Use the output below to test the assumptions of the model. Residual Plots for Exam (%) Normal Probability Plot Versus Fits 30 AD 0.367 P-Value 0.410 Percent Standardized Residual -1 Standardized Residual Fitted Value Histogram Versus Order 4.5 Standardized Residual Frequency 1.0 MM -2.0 -1.5 -1.0 -0.5 0.0 0.5 1.0 1.5 2 4 6 8 10 12 14 16 18 20 22 24 26 28 20 Standardized Residual Observation Order Page 14 of 14Position Low Medium High Inside 69.3 64.7 71.1 Inside 58.3 63.2 73.1 Inside 66.8 62.4 77.5 Inside 62.3 65.7 63.2 Inside 64.2 62.7 67.6 Inside 63.4 62.2 71.3 Inside 67.2 67.9 63.9 Inside 76.6 70.9 74.5 Inside 64.9 69.1 64.7 Inside 70.6 76.0 65.5 Inside 71.1 67.3 70.6 Inside 68.4 64.1 70.5 Inside 67.8 65.1 61.2 Inside 59.3 69.7 71.7 Inside 69.2 69.7 67.9 Inside 62.5 63.2 69.3 Inside 61.3 75.2 68.8 Inside 67.6 61.5 66.6 Inside 65.9 70.3 69.7 Inside 64.2 63.7 69.3 Outside 84.6 100.6 94.9 Outside 74.7 99.8 87.4 Outside 76.6 99.6 87.5 Outside 82.6 106.5 93.7 Outside 76.2 93.2 94.5 Outside 77.1 95 .3 92.9 Outside 85.6 91.0 94.7 Outside 78.7 92.1 89.3 Outside 79.2 99.4 92.8 Outside 73.4 94.6 93.4 Outside 73.2 104.0 93.4 Outside 73.6 93.8 79.6 Outside 82.3 98.1 92.8 Outside 80.7 99.1 92.2 Outside 74.7 97.8 90.9 Outside 75.5 98.5 90.4 Outside 74.0 96.8 82.3 Outside 83.0 104.5 89.2 Outside 72.7 94.4 93. 1 Outside 72.3 99.8 8