Question
In: Advanced Math
6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014...
6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014 2015 2016 2018 2019 Revenue: 30 32 34 35 39 39 45 Let the year 2010 be the base year with x=0.
a) Model the data with a linear function using the points in years 2010 and 2019. Round computed values to 2 decimal places. Also, using your model predict the revenue in the year 2021 accurate to 3 decimal places.
b) Set up a table of (x, y) values to be used for a least squares model and find a linear least squares model y ax b = + for the data. Express the coefficients a and b accurate to 3 decimal places. Also, what is the 2 R value accurate to 3 decimal places?
c) Use your least squares model to predict the revenue in 2020 accurate to 3 decimal places and graph the actual and predicted revenue data superimposed on the same graph.
Solutions
Colby Messinger answered 2 years agoRelated Solutions
Using the data in the following table, 2010 2011 2012 2013 2014 2015 Stock A ...
Using the data in the following table,
2010 2011 2012
2013 2014 2015
Stock A -10% 20% 5%
-5% 2% 9%
Stock B 21% 7% 30%
-3% -8% 25%
consider a portfolio that maintains a 50% weight on stock A and
a 50% weight on stock B.
a. What is the return each year of this portfolio?
b. Based on your results from part (a), compute the average
return and volatility of the portfolio.
Refer to the following mentioned data. (In millions) 2014 2013 2012 Net revenues $ 8,268 $...
Refer to the following mentioned data.
(In millions)
2014
2013
2012
Net revenues
$
8,268
$
8,052
$
7,175
Cost of products sold
5,370
5,140
4,365
Gross margin
$
2,898
$
2,912
$
2,810
(a) Calculate the gross profit ratio for each of the past three
years. (Round your answers to 1 decimal
place.)
(b) Assume that Campbell’s net sales for the first four months
of 2015 totaled $2.7 billion. Calculate an estimated cost of goods
sold and gross profit...
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082...
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
Revenue
4,500
6,860
8,409
9,082
9,808
10,593
11,440
12,355
13,344
14,411
Revenue Growth
52.4%
22.6%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
Production Costs
Fixed Production Expense (excl
depreciation)
575
575
587
598
610
622
635
648
660
674
Variable Production Costs
2,035
3,404
4,291
4,669
5,078
5,521
6,000
6,519
7,079
7,685
Depreciation
152
152
152
152
164
178
192
207
224
242
Total Production Costs
0
2,762
4,131...
Year Population in Millions GDP in Trillions of US$ 2014 318.86 16.29 2011 311.72 15.19 2010...
Year
Population in Millions
GDP in Trillions of US$
2014
318.86
16.29
2011
311.72
15.19
2010
309.35
14.94
2009
306.77
14.54
2008
304.09
14.58
2006
298.38
14.72
2004
292.81
13.95
2003
290.11
13.53
2002
287.63
12.96
2001
284.97
12.71
2000
1999
279.04
12.32
1998
275.85
11.77
1990
249.62
8.91
1989
246.82
8.85
1987
242.29
8.29
1986
240.13
7.94
1985
237.92
7.71
1984
235.82
7.4
1982
231.66
6.49
1981
229.47
6.59
1980
6.5
1979
225.06
6.5
1977
220.24
6.02
1976
218.04...
Year Population in Millions GDP in Trillions of US$ 2014 318.86 16.29 2011 311.72 15.19 2010...
Year
Population in Millions
GDP in Trillions of US$
2014
318.86
16.29
2011
311.72
15.19
2010
309.35
14.94
2009
306.77
14.54
2008
304.09
14.58
2006
298.38
14.72
2004
292.81
13.95
2003
290.11
13.53
2002
287.63
12.96
2001
284.97
12.71
2000
1999
279.04
12.32
1998
275.85
11.77
1990
249.62
8.91
1989
246.82
8.85
1987
242.29
8.29
1986
240.13
7.94
1985
237.92
7.71
1984
235.82
7.4
1982
231.66
6.49
1981
229.47
6.59
1980
6.5
1979
225.06
6.5
1977
220.24
6.02
1976
218.04...
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014....
The following table shows a company's annual revenue (in
billions of dollars) for 2009 to 2014.
Year
Period (t)
Revenue ($ billions)
2009
1
23.6
2010
2
29.2
2011
3
37.8
2012
4
50.3
2013
5
59.8
2014
6
66.6
a)
What type of pattern exists in the data?
The time series plot shows an upward curvilinear trend.
The time series plot shows a downward curvilinear trend.
The time series plot shows a downward linear trend.
The time series...
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014....
The following table shows a company's annual revenue (in
billions of dollars) for 2009 to 2014.
Year
Period
(t)
Revenue ($
billions)
2009
1
23.8
2010
2
29.4
2011
3
37.8
2012
4
50.3
2013
5
59.7
2014
6
66.6
(a) Construct a time series plot.
A time series plot contains a series of 6 points connected by
line segments. The horizontal axis ranges from 0 to 7 and is
labeled: Period. The vertical axis ranges from 0 to 80...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the
estimated team value ($ millions) for the 30 Major League Baseball
teams (Forbes website, January 16, 2014).
Team
Revenue ($ millions)
Value ($ millions)
Arizona Diamondbacks
195
584
Atlanta Braves
225
629
Baltimore Orioles
206
618
Boston Red Sox
336
1312
Chicago Cubs
274
1000
Chicago White Sox
216
692
Cincinnati Reds
202
546
Cleveland Indians
186
559
Colorado Rockies
199
537
Detroit Tigers
238
643
Houston Astros
196...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the
estimated team value ($ millions) for the 30 Major League Baseball
teams (Forbes website, January 16, 2014). Team Revenue ($ millions)
Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225
629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs
274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546
Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers
238 643 Houston Astros 196...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the
estimated team value ($ millions) for the 30 Major League Baseball
teams (Forbes website, January 16, 2014).
Team
Revenue ($ millions)
Value ($ millions)
Arizona Diamondbacks
195
584
Atlanta Braves
225
629
Baltimore Orioles
206
618
Boston Red Sox
336
1312
Chicago Cubs
274
1000
Chicago White Sox
216
692
Cincinnati Reds
202
546
Cleveland Indians
186
559
Colorado Rockies
199
537
Detroit Tigers
238
643
Houston Astros
196...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- How do autobiographical memories change across the lifespan? That is, what is the relationship between one’s...
- Create a Binary Search Tree with the following elements in the order mentioned below: 5, 85,...
- write a MIPS program to ask user to input the number of elements of array
- A disk drive has 300 cylinders, numbered 0 to 299. The drive is currently serving a...
- Write a function that tells whether a hailstone sequence contains a number that is greater than...
- 1D List Practice Could you write the code to solve the following problem that uses 1D...
- How the concept of moral hazard can be applied to the 2008 financial crisis?
ADVERTISEMENT