Nick's Tree Trimming Service was really taking off! He was thrilled that he needed to hire three
Question:
Nick's Tree Trimming Service was really taking off! He was thrilled that he needed to hire three more employees to keep up with all the work. He realized that his years-long strategy of investing in a marketing plan clearly must have something to do with it.
As soon as the business idea was conceived, Nick made a strategic plan that included consistent marketing efforts at steady intervals throughout each year. Every quarter, he updated his messaging, with input from his marketing vendor, and got his updated message out to the public. His quarterly marketing expenses along with the corresponding revenues are as follows.
Quarter | Marketing Cost | Revenues |
1 | $10,000 | $220,000 |
2 | $12,000 | $260,000 |
3 | $12,000 | $330,000 |
4 | $14,000 | $410,000 |
5 | $14,000 | $450,000 |
6 | $16,000 | $425,000 |
7 | $16,000 | $480,000 |
8 | $18,000 | $430,000 |
9 | $18,000 | $470,000 |
10 | $20,000 | $490,000 |
11 | $20,000 | $510,000 |
12 | $22,000 | $470,000 |
(b) Run the regression model in Excel and evaluate it for goodness of fit, significance of the independent variable, and economic plausibility. Specify your final model in Y = m(X) + b format.
Y=$ X+$