latthhuu...

please answer all the questions. i will not accept even if one step miss. thank you.

Q1:

\fA B C D E F G H Shipments and Completion Time W N - Date: June 2003 Day Completion time (hours) | Shipments Completion time (hours) |Shipments 1 1.9 108 Mean 2 7.4 644 Median 3 6.3 298 Mode 4 1.5 35th percentile 10 5 3 223 Q1 12.3 748 Q2 4.5 309 Q3 13 9.3 446 Q4 5.6 109 Range 10 10.4 506 IQR 16 3.7 112 VAR 17 12 5.6 383 Standard Deviation 18 13 10.4 673 Coefficient of Variation 19 14.1 897 20 11.5 26 21 16 6.7 260 22 17 6.3 286 23 18 9.3 718 24 19 3.7 216 25 20 4.5 167 26 21 10 748 27 22 15.3 1075 28 23 1.1 71 29 24 12.6 867 30 25 8.6 699 31 26 10.8 707 32 27 6.7 223 33 28 9.3 629 34 29 7.8 554 35 30 84 671 36 37 38 39 40Exercise1 (30 points) Referring to Data in Assessment R excel file: Calculate the mean, median, mode, 35th, Q1, Q2, Q3, range, interquartile range, variance, standard deviation, coefficient of variation, by calling the necessary excel functions for the "Completion time" and "Shipments". Write your answers in the specified cells of the Data sheet. (20 points) Screenshot Use the Data Analysis Tool Kit to construct the descriptive statistics table for each variable. (10 points)Shipments and Completion Time Date: June 2003 Day Completion time (hours) Shipments 1 1.9 108 2 7.4 644 3 6.3 298 4 1.5 93 10 5 3 223 11 6 12.3 748 12 7 4.5 309 13 8 9.3 446 14 9 5.6 409 15 10 10.4 506 16 11 3.7 17 112 12 5.6 383 18 13 10.4 673 19 14 14.1 897 20 15 11.5 826 21 16 6.7 260 22 17 6.3 286 23 18 9.3 718 24 19 3.7 216 25 20 4.5 167 26 21 10 748 27 22 15.3 1075 28 23 1.1 71 29 24 12.6 367 30 25 8.6 699 31 26 10.8 707 32 27 6.7 223 33 28 9.3 629 34 29 7.8 554 35 30 8.4 671 36 37Exercise 2: Referring to Data in Assessment R excel file: (30 points/ 15 each) a) Build a frequency table for the "Shipments" variable. Screenshot b) Build a frequency, relative, percent frequency and histogram tables for the "Shipments" variable. ScreenshotExercise 3: Referring to Data in Assessment R excel: (20 points/ 5 each) a) Investigate whether the Completion time is affected by Shipments. Carry out a regression analysis and build a scatter diagram with a trend line approximation. Screenshots for Regression analysis and scatter diagram b) At a 0.05 significance level, interpret the p-value to comment whether to reject or to accept the null hypothesis (no significant relation between the Completion time and Shipments). c) Explain the values displayed for Coefficients (Intercept and X Variable 1). d) Write an estimated regression equation for the relationship using the Intercept and X Variable 1 of the form > = bot bix14. A genetic engineering company claims that it has developed a genetically modified tomato plant that yields on average more tomatoes than other varieties. A farmer wants to test the claim on a small scale before committing to a full-scale planting. Ten genetically modified tomato plants are grown from seeds along with ten other tomato plants. At the season's end, the resulting yields in pound are recorded as below. Sample 1 Sample 2 (genetically modified) | (regular) 20 21 23 21 27 22 25 18 25 20 25 20 27 18 23 25 24 23 22 20 a. Construct the 99% confidence interval for the difference in the population means based on these data. b. Test, at the 1% level of significance, whether the data provide sufficient evidence to conclude that the mean yield of the genetically modified variety is greater than that for the standard variety.Question P12 Stan is interested in whether consumers likeability of the brand that he manages differs significantly across consumers with respect to education level. Stan decides to run an ANOVA to test whether a difference in mean likeability of the brand significantly differs across consumer groups categorised based on the highest level of education that they have obtained. The following output is produced: ANOVA Brand A Overall liking (MARKET LEADER) Sum of Squares of Mean Square Sig. Between Groups 8.534 3 2.845 11.703 .000 Within Groups 42.777 176 243 Total 51.311 179 Multiple Comparisons Dependent Variable: Brand A Overall liking (MARKET LEADER) LSD Mean 95% Confidence Interval (1) Education level (J) Education level Difference (1- (highest obtained) highest obtained) J) Std, Error Sig Lower Bound Upper Bound Year 12 Certificate or diploma .078 096 419 .11 27 Bachelor 504 098 000 31 70 Masters or PhD 416 120 001 .18 65 Certificate or diploma Year 12 -.078 096 419 -.27 .11 Bachelor 427 097 000 .23 .62 Masters or PhD 339 119 005 10 .57 Bachelor Year 12 .504 098 000 -,70 -.31 Certificate or diploma .427 097 000 -.62 .23 Masters or PhD ..088 121 468 -.33 .15 Masters or PhD Year 12 ..416 120 001 -.65 -.18 Certificate or diploma -.339 119 005 ..57 .10 Bachelor 088 121 468 -.15 33 *. The mean difference is significant at the 0.05 level. a) What conclusion would you reach about the difference in all means considered simultaneously and what value in the output have you based this on? On what basis did you reach this conclusion (be specific about the value(s) that you used from the output)? b) Make a further comment on what is driving the result; in particular, which two education groups have a significantly higher mean?EThe following table is presenting how much the sell of a product depends on the commercials. _ 21:5 225 23? 240 242 Sell The estimated regression model is {both in linear and quadratic term]: y.=n+dr. +1Jrf+t i=1,....o. Where V1: sell and is dependent on X1 = commercial. Si is random errors. Least square estimate of the regression's coefficients alfa=103.?, beta=4.?5 and gamma=D.{}41 The 95% condence interval has been calculated. fg{ll.'ll"l] och 12110.95] harboriknals.l'_1{l}.] : [1.23. Bilbao\" L {[1351} : {41.03. .[llll). The hypothesis that the cost of the commercials has effect on the sell is calculated. \"as i :3 _ U ml Hm I .3 T"; D i \"M :1. {J mot HM :1r_.f'l]. and Two pvalues are also calculated, what can he said about them? Abonus Bone of the p-values is greater than (3.1 C one of the pvalues is greater than (1.05 D both of the pvalues are greater than [1.05 but less than 0.1 E both of the pvalues are less than (1115