Q3: Time Series Analysis (linear regression model).The Seneca Children's Fund (SCF) is a local charity that runs a summer camp for disadvantagedchildren. The fund's board of directors has been working very hard over recent years to decreasethe amount of overhead expenses, a major factor in how charities are rated by independentagencies. The following data show the percentage of the money SCF has raised that was spent onadministrative and fund-raising expenses for 2000-2014.Period (t) Expense (%)Year2000118.42001215.72002314.82003413.62004512.02005611.32006710.92007810.0200899.22009108.72010117.42011126.52012135.92013145.02014154.8a. Construct a time series plot. What type of pattern exists in the data?b. Use simple linear regression analysis to find the parameters for the line that minimizes MSEfor this time series.c. Forecast the percentage of administrative expenses for 2015.d. If SCF can maintain its current trend in reducing administrative expenses, how long will ittake SCF to achieve a level of 4% or less?

a. In Excel, place the Period values in one column and the Expense values in another column. Select…

Answered: Q3: Time Series Analysis (linear…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Management at Jagoda Wholesalers, in Calgary, Canada, has used time-series regression based on point-of-sale data to forecast sales for the next 4 quarters. Sales estimates are $100,000, $120,000, $140,000, and $160,000 for the respective quarters. Seasonal indices for the four quarters have been found to be1.30, .90, .70, and 1.10, respectively.
The following chart shows the actual sales for the last 12 months for a given company. Assume that sales are best fit by a linear trend and you can use single linear regression to set up a forecasting model. Using the sales data answer below questions (justify your answers): A.What would be the typical linear regression equation for the number of sales? B.Make the sales forecast for period 15 of next year. C. Make the sales forecast for period 17 of next year. D. What is the standard error for the data?
How do you figure this out using conjoint analysis in a linear regression? Determine how various attributes impact the purchase of a car. There are four attributes, each with three levels: Brand: Ford = 1, Chrysler = 2, GM = 3 MPG: 15 MPG = 1, 20 MPG = 2, 25 MPG = 3 Horsepower (HP): 100 HP = 1, 150 HP = 2, 200 HP = 3 Price: $18,000 = 1, $21,000 = 2, $24,000 = 3 The nine product profiles ranked in the data file were evaluated by a consumer. (a) For this market segment, rank the product attributes from most important to least important. Below is the data provided. Brand MPG Power Price Rank 1 1 1 1 4 1 2 2 3 7 1 3 3 2 3 2 1 2 2 6 2 2 3 1 2 2 3 1 3 9 3 1 3 3 8 3 2 1 2 5 3 3 2 1 1
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $2,570,000 $3,750,000 $4,380,000 $5,010,000 $5,520,000 What would be the forecast for next year’s sales using regression to estimate a trend?
Training Dept. of Nimrod Inc wants to develop a regression-based compensation model (compensation in $ per year, Comp) for its mid-level managers to encourage performance, loyalty, and continuing education based on three variables. ▪ Business unit-profitability (Profit per year in $). ▪ Working experiences in Nimrod Inc (Years). ▪ Whether or not a manager has a graduate degree (Grads). If a manager has a graduate degree equals 1, 0 otherwise. Table Attached Question: Use the (full) model to determine the compensation for a manager who has been working for twelve years in a company, no graduate degree, and Nimrod Inc profit of $8.000.000 last year.
The value of a sports franchise is directly related to the amount of revenue that a franchise can generate. The following data represents the value in 2014 (in $millions) and the annual revenue (in $millions) for the 30 Major League Baseball franchises. Suppose you want to develop a simple linear regression model to predict franchise value based on annual revenue generated. Team Revenue Value Baltimore 245 1000 Boston 370 2100 Chicago White Sox 227 975 Cleveland 207 825 Detroit 254 1125 Houston 175 800 Kansas City 231 700 Los Angeles Angels 304 1300 Minnesota 223 895 New York Yankees 508 3200 Oakland 202 725 Seattle 250 1100 Tampa Bay 188 625 Texas 266 1220 Toronto 226 870 Arizona 211 840 Atlanta 267 1150 Chicago Cubs 302 1800 Cincinnati 227 885 Colorado…
Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: Price $2.70 $3.40 $1.90 $4.10 $3.00 $4.00 Using simple linear regression, and given that the price per cup is $1.80, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place). Number Sold 765 510 980 245 320 480
Training Dept. of Nimrod Inc wants to develop a regression-based compensation model (compensation in $ per year, Comp) for its mid-level managers to encourage performance, loyalty, and continuing education based on three variables. ▪ Business unit-profitability (Profit per year in $). ▪ Working experiences in Nimrod Inc (Years). ▪ Whether or not a manager has a graduate degree (Grads). If a manager has a graduate degree equals 1, 0 otherwise. Table Attached Question: Which explanatory variables and interaction terms are significant and not significant at alpha = 5%? Explain your answer briefly.
The registrar at State University believes that decreases in thenumber of freshman applications that have been experiencedare directly related to tuition increases. They have collectedthe following enrollment and tuition data for the past decade: a. Develop a linear regression model for these data andforecast the number of applications for State Universityif tuition increases to $10,000 per year and if tuition islowered to $7000 per year.b. Determine the strength of the linear relationship betweenfreshman applications and tuition using correlation. c. Describe the various planning decisions for State Univer-sity that would be affected by the forecast for freshman applications.
Jensen Tire & Auto is in the process of deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). Weekly Usage Annual (hours) Maintenance Expense 15 22 12 27 22 35 30 42 34 52 19 36 26 38 33 44 42 57 40 45 a. Develop the estimated regression equation that relates annual maintenance expense (in hundreds of dollars) to weekly usage hours (to 3 decimals). Expense = Weekly Usage b. Test the significance of the relationship in part (a) at a 0.05 level of significance. Compute the value of the F test statistic (to 2 decimals). The p value is Select your answer- - Select your answer What is your less than 0.01 between 0.01 and 0.025 - Select your a between 0.025 and 0.05 c. Jensen expe between 0.05 and 0.10 greater than 0.10 sed 30 hours per week.…
An entrepreneur who owns and operates two businesses (A and B) would like to analyze their profitability. They would like your help in the analysis. They give you the annual net profit (in thousands of $) for each business from 2008-2020. Table 1: Annual Net Profits for Businesses A and B Business Year Profit Business Year Profit 2008 -50 2008 -10 2009 57 2009 30 2010 71 2010 27 2011 64 2011 22 2012 60 2012 21 2013 50 2013 20 A 2014 41 2014 24 2015 59 2015 24 2016 71 2016 32 2017 71 2017 36 2018 74 2018 37 019 81 20 40 2020 97 2020 49 a. Suppose you want to graph the distribution of profits. Explain why using only one stem- plot might not be optimal for the analysis. b. Describe the correct stemplot to use. Generate this stemplot. Explain your steps. What can you say about the distribution from this stemplot? c. When are stemplots useful? And why is that? d. Suppose that instead of having 26 observations you have 200 observations. What graph should you generate? e. What other type of…

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS