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

Question

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

Accepted Answer

The Answer is in the image, click to view ...

Question

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

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Sample Size Determination In Clinical Trials With Multiple Endpoints

Students also viewed these Mathematics questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question