The following data set provides information on acres harvested and planted by year and value in the US. Year ASPARAGUS - ACRES HARVESTED ASPARAGUS - ACRES PLANTED 2015 21,700 23,500 2014 23,800 25,800 2013 24,500 26,800 2012 25,300 27,800 2011 26,800 28,400 2010 28,000 29,200 2009 29,200 30,700 2008 32,200 33,700 2007 38,600 40,900 2006 43,200 44,700 2005 49,300 51,700 2004 61,500 66,000 2003 58,000 62,000 2002 66,000 70,500 2001 70,150 75,150 2000 77,400 82,800 1999 75,890 79,590 1998 74,430 From the data set, use the planting data for the United States for recent years. Using a calculator or statistical software, find the equation for the linear regression line for 2010 to 2015. What is the y-intercept?

Determine if the data on petroleum imports provided in Assignment 1 follows a normal distribution.

2. The accompanying data table show the percentage of tax returns filed electronically in a city from 2000 to 2009. Complete the parts below.

Year   Percentage
2000   27
2001   29
2002   35
2003   42
2004   45
2005   49
2006   55
2007   59
2008   61
2009   67

​b) Calculate the MAD for the forecast in part a. ​(Round to two decimal places as​ needed.)

​d) Calculate the MAD for the forecast in part c (Round to two decimal places as​ needed.)

Please show all steps using data set below and excel.

• By using a bivariate regression trend line model, forecast total houses sold for the next five years.
• Prepare a time series plot of these data (years are on the x axis, THS is on the y axis) that shows both actual and forecast THS for the next five years.

Total Houses Sold

Despite the growth in digital entertainment, the nation’s 400 amusement parks have managed to hold on to visitors. A manager collects data on the number of visitors (in millions) to amusement parks in the United States. A portion of the data is shown in the accompanying table.

SOURCE: International Association of Amusement Parks and Attractions.
Click here for the Excel Data File

a. Estimate the linear trend model to make forecasts for 2008. (Round your answers to 2 decimal places.)

yˆ =

b. Estimate the exponential trend model to make forecasts for 2008. (Round your answers to 2 decimal places.)

yˆ =

Consider the following realized annual returns:

1. 2005	-11.3%	52.7%
   2006	-20.8%	-22.0%
   2007	33.1%	6.9%
   2008	13.0%	9.2%
   2009	7.3%	-0.9%

2. Consider the following realized annual returns:
   
   
   
   
   
   
   
   
   

3. Q1 : Suppose that you want to use the 10 year historical average return on the Market to forecast the expected future return on the Market. Calculate the 95% confidence interval for your estimate of the expect return. Q2 : Using the data provided in the table, calculate the average annual return, the variance of the annual returns, and the standard deviation of the average returns for Stock B from 2000 to 2009.

I don't really understand how to estimate revenue. I have been given revenues from previous years and I am being asked to estimate the revenue for FY2020 and explain my rationale. Please help thank you! Please show all relevant work so I can understand how you got to the answer. Thank you!

PS: if possible please use regression including a graph.

A program at SF State is concerned about their graduation rates. Every year they enroll 400 junior-level students, and they’ve been tracking the percent who manage to finish (graduate from) the program in a timely manner. Below are the data for the past 8 years. Express all calculations to 3 significant figures: ie. 12.3% or 0.123 (also 3-decimal spaces).

• Calculate the proportion of the class that graduates each year.
• What kind of control chart should be used in this situation? pChart Justify Why.
• Compute the 3 sigma control limits

Are we in control, give the control

George and June are active volunteers in their local church. George serves as an usher one Sunday morning a month. June sings in the church choir every Sunday morning and attends choir practice each Wednesday evening. Based on the distance from their home to church, June drives 500 miles a year to attend choir practice and sing on Sunday. George leaves home by himself to arrive at church early on the mornings he serves as an usher and put 120 miles on his car this year on these trips. June paid $1,000 for singing lessons to improve her voice so that she might be chosen to sing a solo at church. Are any of these expenses related to serving as an usher or singing in the church choir deductible by George or June?

please asnwer all parts of question 5

Question 5:                         Use Data5 Sheet             

                                This sheet reports monthly value of SP500 index and prices of 5 stocks.

                                REMEMBER to check the timeline order.

                Based on the whole data, create a table reporting the average monthly Return and Total Risk for each of the following stocks:

                Put both Risk and Return in percentage format (say 12.56%)

                (For Total Risk, you use the Standard Deviation based on a Sample – STDEV.S)

                Return=Price(t)/Price(t-1)-1

5a.          Report ticker of the stock with the highest average monthly return

5b.          Report ticker of the stock with the highest total risk

5c.          If you can only invest in 01 stock for only 1 month, which stock and which yearmonth will you choose to maximize your return.

                                Put in the answer sheet that the ticker (in Cap) and year month continuously, say MGM200103.