Answered step by step
Verified Expert Solution
Question
1 Approved Answer
X 2003 3.4225 3.0121 2004 3.7575 3.4315 2005 3.9332 3.6257 2006 4.7512 3.8023 2007 4.9768 4.5400 2008 5.5485 4.8231 2009 5.7225 5.0321 2010 6.1668 5.8500
X
2003 | 3.4225 | 3.0121 |
2004 | 3.7575 | 3.4315 |
2005 | 3.9332 | 3.6257 |
2006 | 4.7512 | 3.8023 |
2007 | 4.9768 | 4.5400 |
2008 | 5.5485 | 4.8231 |
2009 | 5.7225 | 5.0321 |
2010 | 6.1668 | 5.8500 |
2011 | 5.9600 | 5.9523 |
2012 | 6.0927 | 5.6871 |
2013 | 5.6223 | 6.3110 |
2014 | 5.5012 | 6.6321 |
2015 | 4.8853 | 7.7423 |
- Using the data set in the table, model Sales Revenues, R(x)as a quadratic function of year, with x=0 representing 2000. That is, plot this set of data and find the curve of best fit. (Use Excel)(Hint: replace 2003 with x=3, 2004 with x=4, and so forth before plotting the graph and finding the best fit curve.
- Use the function R(x) you found in part a to determine the year (round to the nearest integer when necessary) in which the maximum revenue occurs, and then compare this value with the real data (maximum revenue in the table).
- Write a sentence to describe how well the function fits the data.
- Using the data set in the table, model Cost and Expenses, C(x),as a quadratic function of year, with x=0 representing 2000. That is, plot this set of data and find the curve of best fit.(Use Excel)(Hint: replace 2003 with x=3, 2004 with x=4, and so on before plotting the graph and finding the best fit curve.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started