BUS 306 Quantitative Business Analysis Assignment

Reference no: EM132518008

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 7using the exponential smoothing, assuming that F1= $ 9,000, with α= 0.2 then with α= 0.3.

Attachment:- Quantitative Business Analysis.rar

Reference no: EM132518008

Questions Cloud

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.

Explain how a given investor chooses an optimal portfolio : Explain how a given investor chooses an optimal portfolio, and discuss whether this choice must always relate to a diversified portfolio.

What is the present value of the minimum lease payments : What is the present value of the minimum lease payments? (PV factor for annuity due of 20 semi-annual payments at 8% annual rate, 14.13394)

BUS 306 Quantitative Business Analysis Assignment : BUS 306 Quantitative Business Analysis Assignment Help and Solution, Emirates College of Technology - Assessment Writing Service

Is reason for corporation to maintain accounting records : Baker Construction is a small corporation owned, Under these circumstances, is there any reason for this corporation to maintain accounting records?

Prove mathematically that marginal tax rate : Prove MATHEMATICALLY that Marginal Tax Rate is higher/bigger than Average Tax Rate in progressive tax scheme.

International stage and the impact of a downgrade : Through a statement explain Moody's credit ratings system,its importance on the international stage and the impact of a downgrade on the bond's yields

Accessing non-renewable resources : Countries that claim the most access to the planet's resources continue to grow in population and economy at an increasing pace.

User Account

All Pages