Advanced managerial statistics, Advanced Statistics

Assignment Help:

The objective of this assignment is to test your understanding in the learning outcome (LO2) and learning outcome (LO3) and learning outcome (LO4).

1) This is a grouped assignment maximum of 3 students.

2) The printed-out assignment must be submitted on the stated deadline before 5 p.m. to your respective lecturer's office.

3)  Be sure to include the Assignment Cover Sheet which has been signed by you. A penalty of 10% will apply for each day thereafter unless an extension of time has been granted by your respective lecturer before the due date.

4) The assignment  must be  typed written  in  a report format. Handwritten or soft copy assignment is not acceptable. There is no restriction on the number of pages, font type, font size etc. You may include relevant Excel tables, graphs and charts if necessary. The quality of report presentation should be worthy of submission to your employer or project manager. Some marks will be deducted for submitting a sloppy report.

5) Any computations or formulae used to answer the questions should be attached in the appendix. Focus on interpretation of the findings and less on showing how the computation is done (though you need evidence to back it up). 

You and your team have been hired as  strategic consultants by the hugely successful retailer known as "Cutie Pie". The company sells many products, although one product in particular, a highly innovative car seat, is "Cutie Pie" has hired you to help them better understand the test market data they have compiled from 400 retailers worldwide (found in the excel file called "Cutie Pie.xls").  The variables in the data set include:

Unit Sales = the number of units sold (in thousands),

Competitor's Price = the price for a similar product being sold by a competitor (in RM),

Income Level = average household income in the region (in thousands of RM),

Advertising = amount spent on advertising the product (in thousands of RM),

Price = the price being charged by the retailer (in dollars),

Population = number of people (in thousands) living in the region,

Average Age = average age of the population in the region (in years),

Average Education = average educational level in region,

Shelving Location = quality of the shelf location for the product (good, medium, or bad), Urban or

Rural = description of the region as urban or rural,

Msia  = a categorical variable indicating whether the sales region is in the Malaysia or an international market.

Question

Describe how statistical techniques  can be applied in  marketing segmentation.

Run a multiple regression model with Unit Sales as the dependent variable against all of the available predictor variables, and use that model (available in the "Cutie Pie.xls") to answer the questions below.  Use  = 0.10 where it is applicable.

a) Which independent variables appear to be important predictors of sales?  Why?

b) Which are not? Explain why.

c)  If it costs RM80 to produce each car seat, and advertising RM spent represents the  only additional variable cost associated with producing this product, what would be the effect of increasing the price you charge for each seat at retail, by RM10?  Explain.

d)  Some of the international managers feel that the product is not viewed  favorably outside Malaysia, what should you tell those managers?  Use the following table to assist in your explanation.


Related Discussions:- Advanced managerial statistics

Define kalman filter, Kalman filter : A recursive procedure which gives an ...

Kalman filter : A recursive procedure which gives an estimate of the signal when only the 'noisy signal' can be observed. The estimate is efficiently constructed by putting the exp

Dorfman scheme, An approach to investigations designed to recognize a parti...

An approach to investigations designed to recognize a particular medical condition in the large population, usually by means of a blood test, which might result in the considerable

Business Statistic HW., Hello , I have a business statistic HW that is due ...

Hello , I have a business statistic HW that is due after 23 hours exactly for now . I need full and details answers please , plus they must be in a done and typed in a word or exce

Occam''s razor, Occam's razor  is an early statement of the parsimony princ...

Occam's razor  is an early statement of the parsimony principle, which was given by William of Occam (1280-1349) namely 'entia non sunt multiplicanda praeter necessitatem'; which m

Cellular proliferation models, Cellular proliferation models : Models are u...

Cellular proliferation models : Models are used to describe the growth of the  cell populations. One of the example is the deterministic model   where N(t) is the number of cel

The breusch-pagan test, The Null Hypothesis - H0:  There is no heteroscedas...

The Null Hypothesis - H0:  There is no heteroscedasticity i.e. β 1 = 0 The Alternative Hypothesis - H1:  There is heteroscedasticity i.e. β 1 0 Reject H0 if Q = ESS/2 >

Linear Programming, 1. The production manager of Koulder Refrigerators must...

1. The production manager of Koulder Refrigerators must decide how many refrigerators to produce in each of the next four months to meet demand at the lowest overall cost. There i

The f-wald test, Primary Model Below is a regression analysis without ...

Primary Model Below is a regression analysis without 17 outliers that have been removed Regression Analysis: wfood versus totexp, income, age, nk The regression equat

Forecast, The particular projection which an investigator believes is most ...

The particular projection which an investigator believes is most likely to give an accurate prediction of the future value of some process. Commonly used in the context of the anal

Quantitative Methods, After graduating from Tech Julia was unable to find r...

After graduating from Tech Julia was unable to find regular employment and approached the Director of Athletics at Tech to request that she remain a vendor of the following year.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd