Solved by verified expert:1. The present annual operating budget for a company is $4,876,351. Next year an increase is expected of anywhere from 4% to 7%.The company anticipates opening new stores, anywhere from 5 to 10 new stores. Each new store will add an additional $329,500 to the budget.Create a spreadsheet for next year’s operating budget reflecting the percentage increase (in 0.5% increments) and the addition of the new stores.2. A sample of guests at 4 hotels was taken to see which factors were important in deciding whether or not to return to the hotel: Hotel Palm Leaf Beach Bums Sun n Sand Sea n SurfReason for not ReturningPrice 24 8 38 10Location 37 14 7 20Service 15 6 14 9Accomodation 14 9 7 11Give the expected frequenciesGive the calculated Chi SquareGive the critical Chi SquareIs the reason for not returning independent of hotel (yes or no) Must answer yes or no for independence.Which hotels are under represented in the data for price? (The guests find price to be less important than you would expect.)3. Use 1 way ANOVA for this problem. Work the formulas by writing them into Excel. You may use the Analysis Tool-Pak in Excel ONLY to check your results.ALL WORK MUST BE SHOWN TO RECEIVE CREDIT FOR THIS PROBLEM.Null Hypothesis: No significant difference in gas mileage (shown in miles per gallon) in the 4 gasolines:Exxon Sunoco Hess Shell30 29 29 3225 26 34 2627 29 32 3126 28 33 27Give your calculations for SSAGive your calculations for SSWGive your ANOVA tableGive the calculated FGive the critical FIs the difference significant in the gasolines? (yes or no)Use the Tukey multiple comparisons test to tell which pairs of means show a significant difference:Give the critical range, giving the value for Q, etc.Show the difference between each pair of means.Which pair show a significant difference? Answer the question in terms of the gasolines?Which gasoline would you use for best mileage?4. The data below represent customer satisfaction on a scale of 1 to 10 for different roasts of coffee (Columbian espresso, French mocha, Brazilian, Italian espresso) made in different types of coffee makers (electric, drip, French press).Coffee maker Co. Esp. Fr. Mocha Brazilian It. Esp Electric 7.6 6.4 5.5 8.5 6.8 7.4 6.5 5.7 7.1 7.6 6.8 9.2Drip 8.8 9.9 7.8 8.8 9.6 9.3 7.9 8.3 8.9 8.5 8.2 8.3French Press 9.8 8.9 9.7 8.3 9.7 9.1 9.5 8.7 9.9 8.8 8.6 8.9a) Using 2 way ANOVA give the calculated F for customer satisfaction for: (please answer in order in receive credit). Also be clear which part you are answering in a), b), c) to receive credit.i) The different roastsii) The different coffee makersiii) The Interaction effectb) Does it appear that liking the specific roast is affected by the type of coffee maker (interaction effect). Please answer yes or no.Why? Give a reason for your answer.c) Is the difference significant among the roasts of coffee? Please answer yes or no.Why? Give a reason for your answer.d) Is the difference significant among the types of coffee makers? Please answer yes or no.Why? Give a reason for your answer.e) Use the Tukey multiple comparisons test to show which pairs of roasts or coffee makers show a significant difference. State whether you are using Factor A or Factor B and why. Give the calculations for the Critical Range (give the value of Q, MSE, c, r, n’) and show each pair of means that you are comparing. Make a statement about which pairs (in words) show a significant difference.) f) Sketch the cell means plot.g) Make one statement concerning what your graph shows (something like customers prefer electric coffee makers, etc.)
