Perform the test at the significance level

Reference no: EM132518015

BUS 306 Quantitative Business Analysis - Emirates College of Technology

Problem 1: Problem solving

The Production Cost/crate (AED) and Monthly Sales Volume (hundreds of crates) of a variety of truffles were recorded in a sample of 6 whole sale vegetables markets

Vegetables Market	1	2	3	4	5	6
Production cost/crate (AED)	68	64	60	80	72	76
Monthly sales volume (crates×100)	42	45	36	60	50	61

Question 1. Construct a simple regression model to predict the Monthly Sales Volume by Production Cost.

Question 2. Find the predicted Monthly Sales Volume on that truffles variety in a vegetables market where the Production cost is AED 90/crate.
Question 3. Compute r2 and r for this model. Interpretation their values in this case.

Question 4. Calculate the prediction error for the Monthly Sales Volume value of5000crates based on the regression model constructed previously.

Question 5. Now we want to test the significance of the constructed regression model, by the hypothesis test on whether a linear relationship exists between the Monthly Sales Volume and the Production Cost/crate or not.
a. Construct the ANOVA table.
b. Perform the test at the significance level α = 0.05, and the level α = 0.01.

Problem 2: Problem solving

Ahmed's café specialized in selling hot drinks, is attempting to find the best forecast for the month 7 sales. The café's data on historical monthly sales for the past six months is presented in the following table:

Month	1	2	3	4	5	6	7
Sales ($)	10,000	12,000	13,000	16,000	19,000	23,000	-

Question 1. Compute the sales forecast for month 7using the simple moving average of order 2, then of order 3. Compute the whole series.

Question 2. Compute the sales forecast for month 7 using the weighted moving average of order 2, with weights from the most recent month as 6 and 9, then of order 3 with weights from the most recent month as 5, 3, and 2. Compute the whole series.

Question 3. Compute the sales forecast for month 7 using the exponential smoothing, assuming that F1= $ 9,000, with α= 0.2 then with α= 0.3.

Attachment:- Quantitative Business Analysis.rar

Attachment:- Instructions.rar

Reference no: EM132518015

Questions Cloud

Should appear in entity financial statements for the year : An entity receives rent, What figures, based on these receipts, should appear in the entity's financial statements for the year ended nov. 30, 2018?

Which market structure is considered most efficient : Which market structure is considered most efficient? Explain.

What are the limiting factors for success : Complete your Likert Survey for your self-improvement project. Then, in a Word document, answer the questions below. What are the limiting factors for success?

Describes Main Aspect of Ethic Islam : Shortly Describe the Meaning and Purpose of Ethics According To Emmanuel Kant. Describes Main Aspect of Ethic Islam

Perform the test at the significance level : Compute the sales forecast for month 7 using the simple moving average of order 2, then of order 3. Compute the whole series.

Discuss how different stakeholder personnel inside aca : Discuss in detail how different stakeholder personnel inside ACA Restaurant Café'may be able to contribute to a Master budget.

Construct a simple regression model : Construct a simple regression model to predict the Monthly Sales Volume by Production Cost and Find the predicted Monthly Sales Volume on that truffles

Briefly discuss the portfolio beta : Briefly discuss the Portfolio beta, Reconciliation of the traditional and modern approach and Risk return trade-off. provide the suitable example

Describe the it governance system : First, describe the IT governance system that was in place at the University of the Southeast using both decision rights and structure as the basis.

User Account

All Pages