Camp Rainbow offers overnight summer camp programs for childrenages 10–14 every summer during June and July. Each camp session isone week and can accommodate up to 200 children. The camp is notcoed, so boys attend during the odd-numbered weeks and girls attendduring the even-numbered weeks. While at the camp, participantsmake crafts, participate in various sports, help care for thecamp’s resident animals, have cookouts and hayrides, and helpassemble toys for local underprivileged children.
The camp provides all food as well as materials for all craftclasses and the toys to be assembled. One cabin can accommodate upto 10 children, and one camp counselor is assigned to each cabin.Three camp managers are on-site regardless of the number of campersenrolled.
Following is the cost information for Camp Rainbow’s operationslast summer:
Week | Number of Campers | Cost to Run Camp |
1 | 154 | $11,950 |
2 | 94 | 8,960 |
3 | 168 | 11,080 |
4 | 120 | 9,480 |
5 | 116 | 9,180 |
6 | 182 | 14,330 |
7 | 194 | 14,060 |
8 | 98 | 8,890 |
|
Required:
1. Perform a least-squares regression analysis on CampRainbow’s data. (Use Microsoft Excel or a statisticalpackage to find the coefficients using least-squares regression.Round your answers to 2 decimalplaces.)
| |
| | Coefficients | Intercept | | X Variable 1 | 54.91 |
|
2. Using the regression output, create a costequation (y = a + bx ) for estimating CampRainbow’s operating costs.
| |
| Total Cost = | | + | 54.91 | Number of Campers |
|
3. Using the least-squares regression results,calculate the camp’s expected operating cost if 125 children attenda session. (Round your intermediate calculations and finalanswer to 2 decimal places.)
