Question

please answe all parts of question 4

Year | Period |
Division | Revenue | Number of Customer |

2000 | 1 | A | 706 | 333 |

2000 | 1 | B | 151 | 195 |

2000 | 1 | C | 460 | 222 |

2001 | 1 | A | 879 | 252 |

2001 | 1 | B | 619 | 256 |

2001 | 1 | C | 361 | 376 |

2002 | 1 | A | 260 | 519 |

2002 | 1 | B | 302 | 788 |

2002 | 1 | C | 250 | 62 |

2003 | 1 | A | 588 | 67 |

2003 | 1 | B | 862 | 752 |

2003 | 1 | C | 966 | 250 |

2004 | 2 | A | 724 | 638 |

2004 | 2 | B | 933 | 650 |

2004 | 2 | C | 108 | 785 |

2005 | 2 | A | 749 | 640 |

2005 | 2 | B | 148 | 474 |

2005 | 2 | C | 280 | 51 |

2006 | 2 | A | 429 | 68 |

2006 | 2 | B | 719 | 26 |

2006 | 2 | C | 681 | 594 |

2007 | 3 | A | 264 | 295 |

2007 | 3 | B | 442 | 137 |

2007 | 3 | C | 853 | 49 |

2008 | 3 | A | 479 | 638 |

2008 | 3 | B | 374 | 732 |

2008 | 3 | C | 514 | 92 |

2009 | 3 | A | 599 | 668 |

2009 | 3 | B | 35 | 454 |

2009 | 3 | C | 554 | 350 |

2010 | 4 | A | 214 | 122 |

2010 | 4 | B | 455 | 942 |

2010 | 4 | C | 581 | 993 |

2011 | 4 | A | 22 | 624 |

2011 | 4 | B | 738 | 905 |

2011 | 4 | C | 158 | 47 |

2012 | 4 | A | 24 | 696 |

2012 | 4 | B | 540 | 53 |

2012 | 4 | C | 810 | 162 |

2013 | 5 | A | 176 | 930 |

2013 | 5 | B | 385 | 420 |

2013 | 5 | C | 883 | 962 |

2014 | 5 | A | 18 | 374 |

2014 | 5 | C | 200 | 305 |

2015 | 5 | A | 145 | 123 |

2015 | 5 | B | 456 | 432 |

2015 | 5 | C | 234 | 213 |

**Question
4:** Use
Data4 Sheet

This table reports Revenue and Customer of 3 divisions (A, B, C) of a corporation over time

4a. Create a table reporting the average annual revenue for each division.

( Note: So each division, you have only 1 number for average)

Report the SUM of the 3 average numbers for these 3 divisions (do NOT include or use the Grand Total) in that table?

4b. Create a table reporting total revenue for each year for the whole corporation.

So your table should have 16 rows (or columns) associated with 16 years

(Note: Total sales of the corporation equals to the sum of 3 divisions’ sales)

Sort your table on year (Smallest to Largest)

From that table, report the SUM of total sales of the 3 years: 2000, 2001 and 2002.

4c.
Create a reporting
the total sales for each division in each period (you have a column
called **period in the original table**). See the
table below.

Sort Division from A to Z and sort period from Largest to Smallest.

Report the SUM of the Top left and Bottom Right number (highlighted in the table below).

(do not include Grand total in your calculation)

Answer #1

4a | ||||

Division | Average Annual Revenue | |||

A | 392 | |||

B | 477 | |||

C | 493 | |||

Sum Of the 3 Average Numbers - | 1363 |

4b | ||||

Year | Total Revenue | |||

2000 | 1317 | |||

2001 | 1859 | |||

2002 | 812 | |||

2003 | 2416 | |||

2004 | 1765 | |||

2005 | 1177 | |||

2006 | 1829 | |||

2007 | 1559 | |||

2008 | 1367 | |||

2009 | 1188 | |||

2010 | 1250 | |||

2011 | 918 | |||

2012 | 1374 | |||

2013 | 1444 | |||

2014 | 218 | |||

2015 | 835 | |||

Total Sum For 2000,2001 & 2002 | 3988 |

4c | |||

Division | Period | Total Sales | |

A | 1 | 2433 | |

A | 2 | 1902 | |

A | 3 | 1342 | |

A | 4 | 260 | |

A | 5 | 339 | |

B | 1 | 1934 | |

B | 2 | 1800 | |

B | 3 | 851 | |

B | 4 | 1733 | |

B | 5 | 841 | |

C | 1 | 2037 | |

C | 2 | 1069 | |

C | 3 | 1921 | |

C | 4 | 1549 | |

C | 5 | 1317 | |

Total Sales | 21328 |

3. Below table contains the total number of fatal motor
vehicle crashes in Canada for the period from 1994 to 2011. ( 8
marks)
Year Total crashes Year Total crashes
1994 36254 2004 38444
1995 37241 2005 39252
1996 37494 2006 38648
1997 37324 2007 37435
1998 37107 2008 34172
1999 37140 2009 30862
2000 37526 2010 30296
2001 37862 2011 29757
2002 38491 Total 653782
2003 38477
Answer the following questions:
a. What is the percentage of deaths measured...

You have the following historical annual total returns on
Terlingua Oil & Gas Exploration:
Year
Annual total return (%)
2001
0%
2002
-10%
2003
19%
2004
12%
2005
13%
2006
9%
2007
-4%
2008
5%
2009
2%
2010
4%
Calculate the sample standard deviation of annual return.

Consider the following data:
Number of Deaths in the U.S. by Drug Overdose
Year
2000
2001
2002
2003
2004
2005
2006
2007
2008
Deaths
17,055
17,511
14,316
13,342
17,776
14,516
11,152
18,656
16,643
Find the three-period moving average for the year 2004. If
necessary, round your answer to one decimal place.

The following information was taken from Johnson & Johnson
annual reports. The principal office of Johnson & Johnson is in
New Brunswick, New Jersey. Its common stock is listed on the New
York Stock Exchange, using the symbol JNJ.
Domestic
International
Sales
Sales
Employees
Year
($ million)
($ million)
(thousands)
2000
18,216
11,856
100.9
2001
19,825
12,492
101.8
2002
22,855
13,843
108.3
2003
25,874
16,588
110.6
2004
27,970
19,578
109.9
2005
28,677
22,137
115.6
2006
31,375
23,549
122.2
2007
35,444...

The following data is provided for a market 500 Index: Year
Total return Year Total return 2000 16.0% 2010 2.0% 2001 8.0% 2011
3.0% 2002 -3.0% 2012 3.0% 2003 1.0% 2013 4.0% 2004 5.0% 2014 5.0%
2005 21.0% 2015 4.0% 2006 43.0% 2016 3.0% 2007 4.9% 2017 3.5% 2008
-7.0% 2018 4.5% 2009 0.1% 2019 5.8% Calculate the last 10 -year
arithmetic average annual rate of return on the market Index.
3.78%
2.69%
0.37%
3.93%

The following data is provided for a market 500 Index: Year
Total return Year Total return 2000 16.0% 2010 2.0% 2001 8.0% 2011
3.0% 2002 -3.0% 2012 3.0% 2003 1.0% 2013 4.0% 2004 5.0% 2014 5.0%
2005 21.0% 2015 4.0% 2006 43.0% 2016 3.0% 2007 4.9% 2017 3.5% 2008
-7.0% 2018 4.5% 2009 0.1% 2019 5.8% Calculate the 20 -year
geometric average annual rate of return on the market Index.
5.91%
3.32%
3.77%
0.28%

question 6 You have the following historical annual total
returns on Terlingua Oil & Gas Exploration:
Year
Annual total return (%)
2001
3%
2002
-4%
2003
12%
2004
15%
2005
-2%
2006
3%
2007
17%
2008
0%
2009
-1%
2010
5%
Calculate the sample standard deviation of annual return.
Do not round at intermediate steps in your calculation. Express
your answer in percent. Round to two decimal places. Do not type
the % symbol.

Year
Period (t)
Enrollment
(1,000s)
2001
1
6.5
2002
2
8.1
2003
3
8.4
2004
4
10.2
2005
5
12.5
2006
6
13.3
2007
7
13.7
2008
8
17.2
2009
9
18.1
(b) Use simple linear regression analysis to find the parameters
for the line that minimizes MSE for this time series. If required,
round your answers to two decimal places. y-intercept, b0 = Slope,
b1 = MSE = (c) What is the forecast for year 10? Do not round...

The table below shows the murder rate per 100,000 residents for
a large American city over a twelve-year period.
Year
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
Rate
8.8
7.1
7.2
6.8
6.4
7.1
5.8
6.1
5.4
6.2
6.1
4.9
Enter the coefficients of the regression line for
this data, rounding each to two decimal places:
Slope:
Intercept:
Use your regression line (with rounded
coefficients) to estimate this city’s murder rate in 2012. Round
your...

The table shows estimates of the percentages of Scottish
households that had Internet Service between the years 2001 and
2010.
a. Create a logistic model P(t) which estimates the penetration
of Scottish households with internet service. Use t = 0 to
represent the year 2000.
b. What percentage of Scottish households had internet service by
the year 2018?
c. Find ?′(?)
d. Find ?′(18). What does this number represent.
Year
Percentage
2001
15
2002
20
2003
30
2004
46
2005...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 1 minute ago

asked 5 minutes ago

asked 5 minutes ago

asked 12 minutes ago

asked 12 minutes ago

asked 13 minutes ago

asked 15 minutes ago

asked 15 minutes ago

asked 38 minutes ago

asked 38 minutes ago

asked 42 minutes ago

asked 46 minutes ago