Description 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 Surf Reason for not Returning Price 24 8 38 10 Location 37 14 7 20 Service 15 6 14 9 Accomodation 14 9 7 11 Give the expected frequencies Give the calculated Chi Square Give the critical Chi Square Is 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.
Recent Comments