Buckeye Creek Amusement Park is open from the beginning of May to the end of October. Buckeye Creek relies heavily on the sale of season passes. The sale of season passes brings in significant revenue prior to the park opening each season, and season pass holders con- tribute a substantial portion of the food, beverage, and novelty sales in the park. Greg Ross, director of marketing at Buckeye Creek, has been asked to develop a targeted marketing campaign to increase season pass sales. Greg has data for last season that show the number of season pass holders for each zip code within 50 miles of Buckeye Creek. he has also obtained the total population of each zip code from the U.S. Census bureau website. Greg thinks it may be possible to use regression analysis to predict the number of season pass holders in a zip code given the total population of a zip code. If this is possible, he could then conduct a direct mail campaign that would target zip codes that have fewer than the expected number of season pass holders. *I only need help with #5,6,7 thank you
Managerial Report
1. Compute descriptive statistics and construct a scatter diagram for the data. Discuss your findings.
2. Using simple linear regression, develop an estimated regression equation that could be used to predict the number of season pass holders in a zip code given the total population of the zip code.
3. Test for a significant relationship at the .05 level of significance.
4. Did the estimated regression equation provide a good fit?
5. Use residual analysis to determine whether the assumed regression model is appropriate.
6. Discuss if/how the estimated regression equation should be used to guide the marketing campaign.
7. What other data might be useful to predict the number of season pass holders in a zip code?
| ZIP Code | Population | Season Pass Holders |
| 45220 | 14171 | 224 |
| 45219 | 17576 | 42 |
| 45225 | 13437 | 15 |
| 45217 | 5731 | 78 |
| 45214 | 9952 | 19 |
| 45232 | 6913 | 28 |
| 45223 | 13349 | 83 |
| 45229 | 15713 | 75 |
| 45206 | 11353 | 69 |
| 45202 | 15105 | 83 |
| 45203 | 3411 | 9 |
| 45207 | 8233 | 8 |
| 41074 | 5566 | 36 |
| 41073 | 6193 | 63 |
| 45224 | 21043 | 207 |
| 41071 | 21596 | 133 |
| 45205 | 21683 | 102 |
| 45204 | 6642 | 36 |
| 41016 | 5603 | 42 |
| 45216 | 9028 | 55 |
| 45212 | 22356 | 207 |
| 41011 | 25849 | 193 |
| 41014 | 7913 | 41 |
| 45237 | 21137 | 86 |
| 45208 | 18236 | 424 |
| 45211 | 33968 | 342 |
| 45239 | 26485 | 269 |
| 41075 | 15868 | 236 |
| 45209 | 8941 | 111 |
| 45226 | 5029 | 84 |
| 45238 | 42737 | 564 |
| 45231 | 39939 | 361 |
| 45213 | 11683 | 153 |
| 45215 | 28915 | 308 |
| 45218 | 3917 | 54 |
| 41017 | 40218 | 493 |
| 41076 | 14779 | 176 |
| 45251 | 22887 | 205 |
| 45227 | 18431 | 215 |
| 45247 | 20372 | 357 |
| 41015 | 22298 | 189 |
| 45248 | 22880 | 380 |
| 45236 | 21823 | 310 |
| 45240 | 27033 | 142 |
| 45246 | 13522 | 100 |
| 45230 | 25763 | 423 |
| 45233 | 14175 | 244 |
| 45252 | 4799 | 58 |
| 41018 | 29001 | 244 |
| 45243 | 14755 | 303 |
| 45241 | 25623 | 299 |
| 45014 | 44178 | 307 |
| 45242 | 20015 | 377 |
| 45244 | 26316 | 448 |
| 41059 | 2266 | 22 |
| 41048 | 12597 | 214 |
| 41051 | 18730 | 323 |
| 45255 | 22552 | 307 |
| 45174 | 2072 | 52 |
| 41042 | 50429 | 440 |
| 45002 | 13298 | 184 |
| 45015 | 12504 | 47 |
| 45069 | 46264 | 561 |
| 45052 | 3770 | 52 |
| 45249 | 13432 | 154 |
| 41001 | 16982 | 164 |
| 41005 | 20892 | 209 |
| 45011 | 62303 | 496 |
| 45245 | 17701 | 189 |
| 41091 | 17372 | 226 |
| 45013 | 51730 | 286 |
| 45150 | 31179 | 316 |
| 41094 | 9748 | 106 |
| 45030 | 16386 | 192 |
| 45140 | 52874 | 657 |
| 41063 | 3662 | 19 |
| 45040 | 51183 | 549 |
| 45102 | 22009 | 217 |
| 45039 | 21398 | 278 |
| 41007 | 3215 | 26 |
| 45053 | 3441 | 25 |
| 45157 | 10312 | 72 |
| 45050 | 6988 | 80 |
| 41080 | 2114 | 11 |
| 45067 | 12507 | 62 |
| 45034 | 1227 | 11 |
| 45103 | 29874 | 267 |
| 47025 | 21986 | 154 |
| 45044 | 49621 | 322 |
| 41030 | 7280 | 35 |
| 41092 | 3198 | 18 |
| 45065 | 5194 | 35 |
| 41033 | 1712 | 11 |
| 47060 | 6910 | 38 |
| 41006 | 4835 | 19 |
| 45122 | 12550 | 59 |
| 45042 | 28821 | 91 |
| 45056 | 28811 | 88 |
| 45036 | 36066 | 225 |
| 45064 | 2376 | 9 |
| 47040 | 5242 | 10 |
| 45153 | 2132 | 10 |
| 45152 | 9686 | 101 |
| 47022 | 2740 | 17 |
| 47001 | 10370 | 36 |
| 45162 | 2900 | 11 |
| 45005 | 31944 | 93 |
| 41035 | 9671 | 54 |
| 45106 | 12675 | 61 |
| 45176 | 8485 | 47 |
| 45311 | 7381 | 10 |
| 41043 | 2968 | 7 |
| 45327 | 7961 | 13 |
| 41040 | 7249 | 14 |
| 45066 | 23119 | 129 |
| 41097 | 6854 | 22 |
| 45054 | 1730 | 12 |
| 41095 | 4218 | 11 |
| 45120 | 3774 | 20 |
| 45342 | 31929 | 55 |
| 47032 | 3628 | 10 |
| 45107 | 9608 | 40 |
| 47012 | 10579 | 23 |
| 45130 | 4202 | 17 |
| 45118 | 4239 | 23 |
| 41086 | 1602 | 5 |
| 47018 | 4435 | 12 |
| 45458 | 26281 | 75 |
| 45449 | 19237 | 15 |
| 45068 | 11293 | 28 |
| 47041 | 5544 | 18 |
| 45113 | 4118 | 16 |
| 45154 | 8093 | 41 |
| 45320 | 15282 | 8 |
| 45459 | 26744 | 39 |
| 47031 | 5179 | 12 |
| 41004 | 4311 | 9 |
| 41003 | 2397 | 5 |
| 41010 | 3321 | 5 |
| 41002 | 2104 | 6 |
| 45429 | 25537 | 39 |
| 45305 | 11159 | 16 |
| 45409 | 13554 | 9 |
| 45419 | 15782 | 33 |
| 45121 | 8919 | 26 |
| 45440 | 19463 | 25 |
| 45420 | 24393 | 20 |
| 45410 | 17025 | 7 |
| 45430 | 7137 | 7 |
| 45403 | 16794 | 8 |
| 45142 | 4973 | 10 |
In: Statistics and Probability
An amusement park studied methods for decreasing the waiting time (minutes) for rides by loading and unloading riders more efficiently. Two alternative loading/unloading methods have been proposed. To account for potential differences due to the type of ride and the possible interaction between the method of loading and unloading and the type of ride, a factorial experiment was designed. Use the following data to test for any significant effect due to the loading and unloading method, the type of ride, and interaction. Use . Factor A is method of loading and unloading; Factor B is the type of ride.
| Type of Ride | |||
| Roller Coaster | Screaming Demon | Long Flume | |
| Method 1 | 46 | 54 | 50 |
| 48 | 46 | 46 | |
| Method 2 | 45 | 54 | 48 |
| 47 | 50 | 44 | |
Set up the ANOVA table (to whole number, but -value to 2 decimals and value to 1 decimal, if necessary).
| Source of Variation | Sum of Squares | Degrees of Freedom | Mean Square | -value | |
| Factor A | |||||
| Factor B | |||||
| Interaction | |||||
| Error | |||||
| Total |
The -value for Factor A is - Select your answer -less than .01between .01 and .025between .025 and .05between .05 and .10greater than .10Item 21
What is your conclusion with respect to Factor A?
- Select your answer -Factor A is significantFactor A is not significantItem 22
The -value for Factor B is - Select your answer -less than .01between .01 and .025between .025 and .05between .05 and .10greater than .10Item 23
What is your conclusion with respect to Factor B?
- Select your answer -Factor B is significantFactor B is not significantItem 24
The -value for the interaction of factors A and B is - Select your answer -less than .01between .01 and .025between .025 and .05between .05 and .10greater than .10Item 25
What is your conclusion with respect to the interaction of Factors A and B?
- Select your answer -The interaction of factors A and B is significantThe interaction of factors A and B is not significantItem 26
What is your recommendation to the amusement park?
- Select your answer -Use method 1; it has a lower sample mean waiting time and is the best methodWithhold judgment; take a larger sample before making a final decisionSince method is not a significant factor, use either loading and unloading methodItem 27
In: Statistics and Probability
Suppose a carnival director in a certain city imposes a height limit on an amusement park ride called Terror Mountain, due to safety concerns. Patrons must be at least 4 feet tall to ride Terror Mountain. Suppose patrons’ heights in this city follow a Normal distribution with a mean of 4.5 feet and a standard deviation of 0.8 feet (patrons are mostly children). Make sure to show all of your work in this question. Show the distribution that your random variable follows; state the probability you are asked to calculate; show any tricks you use; show how you standardize, and state your found value from Table A4.
a) [5 marks] What is the probability that a randomly selected patron would be tall enough to ride Terror Mountain?
b) [5 marks] A group of 3 friends want to ride Terror Mountain. What is the probability that their mean height is greater than 4.5 feet?
c) [7 marks] Another group of 5 friends wants to ride Terror Mountain. What is the probability that their mean height is between 4 and 4.25 feet, inclusive?
In: Statistics and Probability
An amusement park studied methods for decreasing the waiting time (minutes) for rides by loading and unloading riders more efficiently. Two alternative loading/unloading methods have been proposed. To account for potential differences due to the type of ride and the possible interaction between the method of loading and unloading and the type of ride, a factorial experiment was designed. Use the following data to test for any significant effect due to the loading and unloading method, the type of ride, and interaction. Use . Factor A is method of loading and unloading; Factor B is the type of ride.
Type of Ride |
|||
| Roller Coaster | Screaming Demon | Long Flume | |
| Method 1 | 41 | 50 | 53 |
| 43 | 42 | 49 | |
| Method 2 | 48 | 51 | 50 |
| 50 | 47 | 46 | |
Set up the ANOVA table (to whole number, but p-value to 2 decimals and F value to 1 decimal, if necessary).
| Source of Variation | Sum of Squares | Degrees of Freedom | Mean Square | F | p-value |
| Factor A | |||||
| Factor B | |||||
| Interaction | |||||
| Error | N/A | ||||
| Total |
In: Statistics and Probability
Jorge was at the park playing with friends. He found a typical die with 6 sides on the ground. He took it home and rolled it 100 times and recorded the results (found in the table below). He wanted to see if the die was a 'fair die' or if it was weighted on one side so somone could cheat when playing games!
Is this a 'fair die' or has it been tampered with? Test at the α=0.05 level of significance.
Which would be correct hypotheses for this test?
H0:μ1=μ2
; H1:μ1≠μ2
H0:
The die is a fair die; H1:
The die has been tampered with
H0:p1=p2
; H1:p1≠p2
H0:
The die has been tampered with; H1:
The die is a fair die
Roll count:
Rolled Count
1 1
2 5
3 4
4 6
5 9
6 75
Test Statistic:
Give the P-value:
Which is the correct result:
Reject the Null Hypothesis
Do not Reject the Null Hypothesis
Which would be the appropriate conclusion?
There is enough evidence to suggest that the die has been
tampered with.
There is not enough evidence to suggest that the die has been
tampered with.
In: Statistics and Probability
The Ocean City water park is considering the purchase of a new log flume ride. The cost to
purchase the equipment is $5,000,000, and it will cost an additional $380,000 to have it installed. The equipment has an expected life of six years, and it will be depreciated using a MACRS 7-year class life. Management expects to run about 150 rides per day, with each ride averaging 25 riders. The season will last for 120 days per year. In the first year the ticket price per rider is expected to be $5.25, and it will be increased by 4% per year. The variable cost per rider will be $1.4, and total fixed costs will be $425,000 per year. After six years, the ride will be dismatled at a cost of $215,000 and the parts will be sold for $450,000. The cost of capital is 8.5%, and its marginal tax rate is 35%.
a. Calculate the initial outlay, annual after-tax cash flow for each year, and the terminal cash flow.
b. Calculate the NPV, IRR, and MIRR of the new equipment. Is the project acceptable?
c. Create a Data Table that shows the NPV, IRR, and MIRR for MACRS classes of 3, 5, 7, 10, 15 and 20 years. What do you conclude about the speed of depreciation and the profitability of an investment?
d. Using Goal Seek, calculate the minimum ticket price that must be charged in the first year in order to make the project acceptable.
In: Finance
Thunder Corporation, an amusement park, is considering a capital investment in a new exhibit. The exhibit would cost $147,150 and have an estimated useful life of 6 years. It can be sold for $68,000 at the end of that time. (Amusement parks need to rotate exhibits to keep people interested.) It is expected to increase net annual cash flows by $24,000. The company’s borrowing rate is 8%. Its cost of capital is 10%. Click here to view the factor table. Calculate the net present value of this project to the company and determine whether the project is acceptable. (If the net present value is negative, use either a negative sign preceding the number eg -45 or parentheses eg (45). For calculation purposes, use 5 decimal places as displayed in the factor table provided. Round present value answer to 0 decimal places, e.g. 125.)
| Net present value: |
The project:
In: Accounting
Suzy’s Cool Treatz is a snow cone stand near the local park. To plan for the future, the owner wants to determine her cost behavior patterns. She has the following information available about her operating costs and the number of snow cones served.
|
Month |
Number of snow cones |
Total operating costs |
|
January |
3,500 |
$5,000 |
|
February |
3,800 |
$4,800 |
|
March |
5,000 |
$6,800 |
|
April |
3,600 |
$5,450 |
|
May |
4,700 |
$6,200 |
|
June |
4,250 |
$5,950 |
Suzy uses the high-low method to determine her operating cost equation. What are her estimated costs at 4628 snow cones? When calculating the variable cost per unit, round your answer to two decimal places before completing your calculations. Do not use dollar signs, commas or decimals in your answer. Input your answer to the nearest whole number.
In: Accounting
Adjusted WACC. Hollydale's is a clothing store in East Park. It paid an annual dividend of $1.20 last year to its shareholders and plans to increase the dividend annually at 3.0%. It has 590 comma 000 shares outstanding. The shares currently sell for $17.37 per share. Hollydale's has 11 comma 000 semiannual bonds outstanding with a coupon rate of 6%, a maturity of 24 years, and a par value of $1 comma 000. The bonds are currently selling for $638.46 per bond. What is the adjusted WACC for Hollydale's if the corporate tax rate is 40%?
In: Finance
A new roller coaster at an amusement park requires individuals to be at least 4' 8"
(56 inches) tall to ride. It is estimated that the heights of 10-year-old boys are normally distributed with
mu equals μ=55.0 inches and sigma equals σ=4 inches.
a. What proportion of 10-year-old boys is tall enough to ride the coaster?
b. A smaller coaster has a height requirement of
50 inches to ride. What proportion of 10-year-old boys is tall enough to ride this coaster?
c. What proportion of 10-year-old boys is tall enough to ride the coaster in part b but not tall enough to ride the coaster in part a?
In: Math