Reminder: hand written work is not accepted. Show work and formula 1. The presen
ID: 3335382 • Letter: R
Question
Reminder: hand written work is not accepted.
Show work and formula
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.
Null Hypothesis: No significant difference in gas mileage (shown in miles per gallon) in the 4 gasolines:
Exxon Sunoco Hess Shell
30 29 29 32
25 26 34 26
27 29 32 31
26 28 33 27
Give your calculations for SSA
Give your calculations for SSW
Give your ANOVA table
Give the calculated F
Give the critical F
Is 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?
Explanation / Answer
I will do only one question out of these 3
Question 2
H0 : Reason of not returning is independent for any hotel.
Ha : Reason of not returning is dependent for any hotel.
Observed Table for CHi - square test statistic
Expected Frequency Table
Expected frequency for Price factor and Palm Leaf = Total price factor * Total palm leaf/ Total sample size = 80 * 90/243 = 29.63
similarly, we will calculate other expected frequency
Expected frequency table
Chi - square table
X2 = (Oi - Ei)2/Ei
X2 = 66.29
Critical chi-square statistic
x2 cr for dF = 3 * 3 = 9
x2 cr = 16.9190
so here X2 > X2cr so we shall reject the null hypothesis and can conclude that Reason of not returning is dependent for any hotel.
Reasons for not returning Palm Leaf BeachBums Sun n sand Sea nd surf Total Price 24 8 38 10 80 Location 37 14 7 20 78 Service 15 6 14 9 44 accomodation 14 9 7 11 41 Total 90 37 66 50 243