Using some historical data for the past 40 periods (see attachment) I need to make a forecast for the next 12 periods (periods 41 thru 52) using whatever is the best/most accurate of the simple forecasting techniques we have covered so far in our 2nd year class. These include: 1)Simple Moving Average 2)Weighted Moving Averag
Using some historical data for the past 40 periods (see attachment) I need to make a forecast for the next 12 periods (periods 41 thru 52) using whatever is the best/most accurate of the simple forecasting techniques we have covered so far in our 2nd year class. These include: 1)Simple Moving Average 2)Weighted Moving
Given a set of historical data (see attachment) I need to make a forecast for 26 periods using whatever is the best/most accurate of the simple forecasting techniques we have covered so far in our 2nd year class. These include: 1)Simple Moving Average 2)Weighted Moving Average 3)Exponential Smoothing 4)Linear Regre
Using SPSS, MiniTab, or Excel and the data provided in the attached Excel spreadsheet see if sales (sales12x) is is influenced by the number of mailings (mail12x)and contacts( contacts)? Explain any other correlations you may discover. forcasting: For all of the customers that have had no sales (zero) in the (sales12x
Please see the attached file for full problem description. --- A popular, nationwide standardized test taken by high-school juniors and seniors may or may not measure academic potential, but we can nonetheless examine the relationship between scores on this test and performance in college. We have chosen a random sample of
Please see the attached file for full problem description. --- Bivariate data obtained for the paired variables and are shown below, in the table labelled "Sample data." These data are plotted in the scatter plot in Figure 1, which also displays the least-squares regression line for the data. The equation for this line is
Please see the attached file for full problem description. --- Bivariate data obtained for the paired variables and are shown below, in the table labelled "Sample data." These data are plotted in the scatter plot in Figure 1, which also displays the least-squares regression line for the data. The equation for this line is.
Please see the attached file for full problem description. --- Bivariate data obtained for the paired variables and are shown below, in the table labelled "Sample data." These data are plotted in the scatter plot in Figure 1, which also displays the least-squares regression line for the data. The equation for this line is
This problem analyzes the asc.xls data set. The purpose of this problem is to predict which customers will respond to a particular catalog and how much they will spend. The variable targdols gives the amount that each customer spent in response to a particular mailing. The variables recency, totfreq, and totfreq give RFM for th
The marketing manager for a large nationally franchised lawn service company would like to study the characteristics that differentiate homeowners who do and do not have a lawn service. A random sample of 30 homeowners located in a suburban area near a large city was selected. Use the lawn.xls dataset in SPSS, Minitab or Excel.
Question 1) Consider a direct marketing company where customers become members, pay periodical fees, and cancel membership at some time, e.g., a CD club. Assume the annual discount rate is 8%. 1. Suppose that the expected monthly cash flow from customers is $15. Compute the expected number of months until canceling and LTV for
Data from 60 cities has been collected to investigate how human mortality relates to different socioeconomic factors. The variables are: Mortality (age adjusted mortality) Education (median education) PopDensity (Population density) %Non-white (Percentage of non-whites) %WC (Percentage of white collar workers) Populatio
Please label your answers in bold and away from any calculations. Bivariate data obtained for the paired variables and are shown below, in the table labelled "Sample data." These data are plotted in the scatter plot in Figure 1, which also displays the least-squares regression line for the data. The equation for this line is
I am having trouble with this problem. Please mark your final answers in bold. An advertising firm wishes to demonstrate to its clients the effectiveness of the advertising campaigns it has conducted. The following bivariate data on 15 recent campaigns, including the cost of each campaign (denoted by x, in millions of dollars) a
Horace Mann, principal of Jones Public School, has decided to construct a time series model to obtain a 2- and a 3-period moving average to forecast student enrollments for next term. Which statement is true concerning the accuracy of each forecast that Horace will obtain? (which one) a. The 2-period forecast will be more accura
For this assignment, our teacher gave us data for 144 periods and asks us... "use the best forecasting technique for forecast 12 periods into the future. State all relevant assumptions, and briefly describe the technique(s) you used." Now, I'm assuming this would be a seasonal forecast, but I'm not sure what technique to
Generico has been manufacturing videotapes since 1982. The 3-hour VHS format is by far the largest component of their product mix. Historical demand for these items since 1992 is listed below <data attached>. Don Wirtz, general managing partner of Generico is concerned about the state of the current market for VHS format ta
I. The Director of the Work/Study Program wanted to develop a model to predict a student's grade point average, GPA, in relation to the number of hours worked. Choose a random sample of 20 students who work and are full-time students from our population in order to study the relationship between number of hours worked and gpa.
Let Y1 and Y2 be independent random variables, with means theta, and 3*theta, respectively. Find the least squares estimate of theta. (See attachment)
A survey shows the following relationship between advertisement and sales # of Ads Sales(000) 11 4 12 2 13 6 14 10 15 8 a) Compute the coefficient of regression for this survey b) What is the value of point of intercept?
Please see attachment.
6. Finley Heaters Inc. is a mid-sized manufacturer of residential water heaters. Sales have grown during the last several years, and the company's production capacity needs to be increased. The company's management wonders if 'national housing starts' might be a good indicator of the company's sales: "
Horace Mann, principal of Jones Public School, has decided to construct a time series model to obtain a 2- and a 3-period moving average to forecast student enrollments for next term. Which statement is true concerning the accuracy of each forecast that Horace will obtain? (which one) a. The 2-period forecast will be more ac
Sporty Inc., a regional chain of sporting goods stores, wants to investigate why some of their stores in university towns have higher sales than other stores. Accordingly, they randomly sampled stores nationwide and collected information on yearly sales ($1000s), yearly advertising expenditures ($1000s), number of students at t
a) Display this time series as a line graph (please use excel). b) Find the 4-period MA (moving average) forecast for January 1997. c) Find the MSE (mean square error) for the 4-period MA (mean average) model. See attached file for full problem description.
Question 1 (30 pts.): The Excel file attendance.xls contains the daily attendance data at a theme park for a period of four weeks in summer. The park manager wants to use these data to make forecasts for the following summer week. a) Make a time-series plot of the data. Is there a trend? Is there seasonality in the data? Wha
A). Create a scatter plot (using excel) of the data. b). Find the equation of the linear regression line. c). Plot the regression line on the same plot as the data. d). How well do you think the line fits the data? e). Use the regression equation to predict the number of officers hired for each city. f). Calculate
A linear regression between Y and X produced the following equation for the least squares line: = -4.13 + 2.1x Which of the following statements concerning this relationship is true? a.For every one-unit increase in X, Y increases 4.13 units. b.For every one-unit increase in X, Y decreases 2.1 units. c.For ever
Which one of the following statements concerning the regression line is true? a. There is a positive linear relationship between the two variables. b. The slope is greater that 1. c. The intercept is at or near 30. d. Vehicles with larger wheelbases have the worst fuel economy. The slope of the regression line, b1, is at
A). Predict the average price of bread for the next 3 months (time = 205,206,207). b). Test the significance of the slope for this model. c). Is the graph consistent with the results of your hypothesis test? Explain why or why not.