Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Topic - Business Forecasting
Question: Use word and any formulas put in excel.
A retailer of motorcycle accessories wants to develop a model to make sales forecasts based on the dataset in the table below. The first column is sales for each geographic region. Units are millions of euros. We have data for 11 regions; there are more regions for which we have no data. The second column is number of retail outlets in each region. The third column is the number of motorcycles registered in each region. Units are millions of motorcycles.
a. First, please analyze the correlation matrix.
b. Can you develop an effective predictive equation from the results of multiple regression on these data?
c. In region 12 the number of outlets is 2,500 and the number of motorcycles is 20.2 million. Can sales be forecast for region 12?
d. Discuss the accuracy of the forecast for region 12 (item c above).
e. How can this regression equation be improved?
Sales
Outlets
Motorcycles
52.3
2011
24.6
26
2850
22.1
20.2
650
7.9
16
480
12.5
30
1694
9
46.2
2302
11.5
35
2214
20.5
3.5
125
4.1
33.1
1840
8.9
25.2
1233
6.1
38.2
1699
9.5
If the budget analyst wanted to build a regression model using only two independent variables to predict nursing salaries, what variables should be used?
The length of human pregnancies from conception
Humane society claimes that less than 34% of U.S. households own a dog. In a random sample of 405 U.S. households, 152 say they own a dog. At x=0.03, is there enough evidence to support the society's claim?
When using the binomial probability distribution for analyzing guesses on a multiple-choice quiz, what is wrong with letting "p" denote the probability of getting a correct answer while "x" counts the number of wrong answers?
What decision model should be used, What is the optimal decision?
Calculate the ANOVA table for the model, which you have determined. What is the estimate of the variance in the electric power measurement?
A bag contains 12 white and 18 black balls. Two balls are drawn in succession without replacement.What is the probability that first is white and second is black?
Having just made what you believe to be a Type II error, using an independent groups design and a t test analysis, name all the things you might do in the next experiment to reduce the probability of a Type II error.
Calculate the test statistic and p-value for each sample. State the conclusion for the specified a. What is probability of producing at least 232,000 barrel
Decision Trees are graphic displays of the decision process. When do you feel it is appropriate to use decision trees?
A quality control inspector believes that the variance in the diameters of soda cans, measured in millimeters, is greater for soda cans produced by Machine A than for soda cans produced by Machine B. Does the evidence support the inspector's claim
Find the mean, median and mode of this information and what are the range and standard deviation - Use the Empirical Rule to establish an interval which includes about 95 percent of the observations.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd