Quarter Enrollments in Business Statistics course at a major university are given in the EXCEL worksheetEnrollment:
b. Use the additive model to forecast for the enrollments for Fall 2013, Winter 2014, and Spring 2014.
| Quarter | Enrollment | |
| 2009 | Fall | 705 |
| 2010 | Winter | 734 |
| Spring | 661 | |
| Fall | 760 | |
| 2011 | Winter | 780 |
| Spring | 700 | |
| Fall | 863 | |
| 2012 | Winter | 860 |
| Spring | 750 | |
| Fall | 880 | |
| 2013 | Winter | 900 |
| Spring | 780 |
Please show step by step instructions using excel:
In: Statistics and Probability
All Time Box Office Revenues Aggregated by Months
|
Rank |
Month |
Gross |
Movies Tracked |
|
1 |
February, 2009 |
796,343,640 |
161 |
|
2 |
February, 2010 |
745,693,066 |
173 |
|
3 |
February, 2008 |
659,270,466 |
193 |
|
4 |
February, 2004 |
666,141,251 |
201 |
|
5 |
February, 2007 |
693,647,238 |
176 |
|
6 |
February, 2003 |
613,460,961 |
207 |
|
7 |
February, 2005 |
692,957,988 |
185 |
|
8 |
February, 2006 |
652,426,175 |
193 |
|
9 |
February 2002 |
529,353,345 |
98 |
In: Statistics and Probability
Passing the ball between two players during a soccer game is a critical skill for the success of a team. A random sample of passes made by the English and German teams in the 2010 World Cup was drawn, and the number of successful passes in each sample was counted. Is there any difference in accuracy if we assume a level of significance of .01? See data below:
| Germany | England | |
| # of successful passes | 69 | 71 |
| Total in the sample | 76 |
91 |
Reject the null, there is no difference in accuracy
Do not reject the null, there is no difference in accuracy
Reject the null, there is a difference in accuracy
Do not reject the null, there is a difference in accuracy
In: Statistics and Probability
A restaurant has the following table of values for some of its burrito sales during January from the previous 10 years
| Years | 2007 | 2009 | 2010 | 2011 | 2013 | 2015 |
| Price | 10.50 | 9 | 10.75 | 11 | 13 | 12.25 |
| Sales | 110 | 165 | 105 | 98 | 75 | 80 |
a. Find a cubic model for the price demand functions. What is the correlation coefficient?
b. Using your cubic model, find a model for the revenue
c. What price will the revenue be maximized
d. Does your answer from part c guarantee that the profit will be maximized? why or why not?
In: Advanced Math
Consider the following information for a mutual fund, the market index, and the risk-free rate. You also know that the return correlation between the fund and the market is 0.89. Year Fund Market Risk-Free 2008 -21.2 % -40.5 % 2 % 2009 25.1 21.1 4 2010 14 14.2 2 2011 6.2 8.8 4 2012 -2.16 -5.2 3 Calculate Jensen’s alpha for the fund, as well as its information ratio. (Round your Jensen’s alpha answer to 2 decimal places & Information ratio answer to 4 decimal places. Omit the "%" sign in your response.)
In: Finance
In: Economics
Use the following data to answer the following questions; A. Calculate nominal GDP in 2012 and 2013 B. Calculate real GDP in 2012 and 2013 (make 2012 the base year) Quantities 2012 2013 Apples 70 160 Oranges 90 220 Prices 2012 2013 Apples $.50 $1 Oranges $.25 $2
The BLS reported the following CPI data.
What is the rate of deflation between June 2008 and 2009? (Even though the price level fell, you still work the problem the same)
| June 2008 | 217.3 |
| June 2009 | 214.6 |
| June 2010 | 216.9 |
In: Economics
Ice to Steam via Water Due this Friday, Dec 4 at 11:59 pm (EST) How much heat is required to change a 49.4 g ice cube from ice at -13.7°C to water at 50°C? (if necessary, use cice=2090 J/kg°C and csteam= 2010 J/kg°C) 2.82×104 J You are correct. Your receipt no. is 150-2609 Help: Receipt Previous Tries How much heat is required to change a 49.4 g ice cube from ice at -13.7°C to steam at 120°C?
In: Physics
Please Convert yearly data to quarterly data on excel
Income Level
Canada United States
Year Annual Annual
2000 22750 59938
2001 23110 58609
2002 23580 57947
2003 25480 57875
2004 29530 57674
2005 34300 58291
2006 37890 58746
2007 41530 59534
2008 44930 57412
2009 43220 57010
2010 44480 55520
2011 47180 54673
2012 51080 54569
2013 52800 56479
2014 52190 55613
2015 47580 58476
2016 43940 60309
2017 43000
2018 44860
In: Finance
Subject: Computer Algorithms
3) Design an efficient algorithm that sorts an array containing 2 sorted sets of numbers, such as A=[3,4,7,9,13,1,5,6,8] (Note that [3,4,7,9,13] and [1,5,6,8] are both sorted, but A is not). Your algorithm declaration should look like this:
MYSORT(A,p,n)
where A is the input array, p is the index to the first element of the second set of numbers, and n is the length of array A.
Calculate the asymptotic running time and space of you algorithm.
Reference book
Introduction to Algorithms 3rd edition
Ebook URL:
http://ce.bonabu.ac.ir/uploads/30/CMS/user/file/115/EBook/Introduction.to.Algorithms.3rd.Edition.Sep.2010.pdf
In: Computer Science