### Forecasting Methods: Example Questions

What forecasting methods are used at your organization? Who does the forecasting? What is forecasted? What should be forecasted?

Explore BrainMass

- Anthropology
- Art, Music, and Creative Writing
- Biology
- Business
- Chemistry
- Computer Science
- Drama, Film, and Mass Communication
- Earth Sciences
- Economics
- Education
- Engineering
- English Language and Literature
- Gender Studies
- Health Sciences
- History
- International Development
- Languages
- Law
- Mathematics
- Philosophy
- Physics
- Political Science
- Psychology
- Religious Studies
- Social Work
- Sociology
- Statistics

What forecasting methods are used at your organization? Who does the forecasting? What is forecasted? What should be forecasted?

One of the editors of a major automobile publication has collected data on 30 of the best-selling cars in the United States. The data are in a file called Automobiles( attached). suppose the magazine editor wishes to examine the relationship between price of the vehicle and the horsepower of the engine. a) Toyota considered

One of the editors of a major automobile publication has collected data on 30 of the best-selling cars in the United States. The data are in a file called Automobiles( attached). The editor just purchased a Cadillac Sedan DeVille which weighs 4,012 pounds. His previous car was a Toyota Camry which weighs 3,241 pounds.. a) The

A 1998 article in Fortune magazine entitled " The 100 Best Companies to Work for in America" (January 12, 1998) contained data on the 100 companies. These data are included in the data file called Best-Companies ( attached). Two variables of interest are the revenues of the company and the number of hours of training per year pe

One of the editors of a major automobile publication has collected data on 30 of the best-selling cars in the United States. The data are in a file called Automobiles( attached). The editor is particularly interested in the relationship between highway mileage and curb weight of the vehicles. a) Develop a linear regression mo

The following data have been collected by an accountant who is performing an audit of account balances for a major retail company. The population from which the data were collected represented those accounts for which the customer had indicated the balance was incorrect. The dependent variable, y, is the actual account balance a

The State Department of Transportation has conducted a study of 100 randomly selected vehicles in which the speed of the vehicle and age of the driver were measured. The Data were collected from a stretch of highway that produces an unusually high accident rate. A regression model was developed, with vehicle speed being predicte

You are given the following results from computations pertaining to a simple linear regression application. Y=5,723.0+145x n= 25 Sb1=10.80 a) based on the statistics supplied, can you conclude that there is a significant linear relationship between x and y? test at a significant level of 0.05 b) interpret the slope coef

A publishing company in New York is attempting to develop a model that can use to help predict sales for textbooks it is considering for future publication. The marketing department has collected data on several variables from a random sample of 15 books. These data are given in the attached excel file. Answer these questions

Interpreting Summary Output for Simple Linear Regression (Round all calculations to 4 places.) Using the second attached BALDOR data and Excel output, complete the following: 1. What is the value of the correlation coefficient? 2. What is the value of the coefficient of determination? 3. What is

Using the Excel SUMMARY OUTPUT below, complete the following: All calculations accurate to four decimal places 1.) What is the value of the correlation coefficient? 2.) What is the value of the coefficient of determination? 3.) What is the value of the y-intercept of the least squ

Question #1: The following data have been collected by an accountant who is performing an audit of paper products at a larger office supply company. The dependent variable, y, is the time taken (in minutes) by the accountant to count the units. The independent variable, x, is the number of units on the computer inventory record.

In this problem, a multiple linear regression analysis is done with the software Minitab and the results of the analysis are interpreted. Using the Minitab output, the following questions are answered. a) Report the estimated regression equation and the value of R-square. b) Construct a 95% confidence interval for the slope

Multiple choice/ short answer See attached revisedq1.doc Word document for the multiple choice questions. Appears part of the information needed to answer was missing from the original posting. The information is now included in the revised document.

Logistic regression: Interpretation of computer output In this problem, the computer output from a logistic regression analysis is provided. We are asked to provide the following: a) Test the model significance at the .05 level. b) State the null and alternative hypothesis, the p-value and the decision fro

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

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.

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

The least-squares regression line for these data has a slope of approximately 0.18. Answer the following. Carry your intermediate computations to at least four decimal places, and round your answers as specified below. (see attachment for full questions)

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.