Explore BrainMass

Linear Regression

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

In normal circumstances, the zoo may be able to achieve its target goal and attract an annual attendance equal to 40% of its community. Approximately 35% of all visitors are adults. Children accounted for one-half of the paid attendance. Group admissions remain a constant 15% of zoo attendance.

Due to its northern climate, the zoo conducts its open season from mid-April until mid-October. It reopens for 1 week at Halloween and for the month of December. Zoo attendance depends largely on the weather. For example, attendance was down during the month of December 1995, which established many local records for the coldest temperature and the most snow. Variations in weather also affect crop yields and prices of fresh animal foods, thereby influencing the costs of animal maintenance.

Would simple linear regression analysis be the appropriate forecasting technique to calculate the expected gate admittance figures and revenues for both 1999 and 2000?

What factors other than admission price influence annual attendance and thus should be considered in the forecast?

Please refer to the attached document for complete question, with the attendance for the years 1989-1998.

© BrainMass Inc. brainmass.com October 25, 2018, 5:45 am ad1c9bdddf


Solution Summary

The solution does a great job of answering the question. The solution is well explained and very easy to follow along. All the steps are clearly shown. Overall, an excellent solution.

The attachment contains the solution in Excel format.

See Also This Related BrainMass Solution

Calculations for Simple Linear Regression

6. Following is a table with the set of x-values and their corresponding y-values filled in

xi yi xi2 xiyi
1 6
1 7
2 5
3 5
4 4
6 2
7 2
totals __ __ ___ ____
(sum of all values in each column)

a. Complete the table.

b. Find SSxy

c. Find SSxx

d. Find the least squares line.

e. Calculate SSE

f. Calculate s^2

View Full Posting Details