Ask Question, Ask an Expert


Ask Advanced Statistics Expert

problem 1: The average prices for a product in 12 stores in a city are shown below:

$1.99, $1.85, $1.25, $2.55, $2.00, $1.99, $1.76, $2.50, $2.20, $1.85, $2.75, $2.85

Test the hypothesis that the average price is higher than $1.87. Use level of significance α = 0.05.

problem 2: A store wants to predict net profit as a function of sales for next year. Historical data for 8 years is illustrated in the table below.

249_scatter diagram.jpg

a) Make a scatter diagram for the data, by using Sales for the independent variable and Net Profit for the dependent variable. Insert the trend line and add the equation and R2 value to the diagram.

b) Find out the correlation coefficient. Comment on the value of the correlation coefficient.

c) Find out the predicted value of Y given X = 75. Give an interpretation of the predicted value in the context of the problem.

d) Make an ANOVA table and attach the summary output.

problem 3: Last week’s sales of a product at a retail store are shown in the given table:

586_mean absolute deviation.jpg

a) Use the 3-day moving average method for forecasting days 4-7.

b) Use the 3-day weighted moving average method for forecasting days 4-7. Use Weight 1 day ago = 4, Weight 2 days ago = 3 and Weight 3 days ago = 2.

c) Compare the methods by using the Mean Absolute Deviation.

problem 4: The revenue and cost functions for producing and selling quantity x for a certain company are described below.

R(x) = 12x – x2
C(x) = 21 + 2x

a) Find out the profit function P(x).

b) find out the break-even quantities.

c) Find out the average cost at the break-even quantities.

d) Find out the marginal revenue R’(x).

e) Find out the marginal cost C’(x).

f) At what quantity is the profit maximized?

problem 5: A company manufactures two products, Product A and Product B. The wholesale price and manufacturing cost of each product are illustrated below.

546_LP model.jpg

The company will generate a minimum of 10,000 of each item. Given the number of hours, the company can sell no more than 18,000 of Item A and 20,000 of Item B. Assume the company has 100,000 hours of assembly time available, how many of each item must it produce in order to maximize profits while meeting all essential constraints? Give the LP Model and use both the graphical method and Excel to find out the optimal solution.

problem 6: A company purchases its merchandise for $10 and sells for each item for $20. The pay-off table for the problem is given below.

770_pay off table.jpg

What is the decision based on each of the given criteria? Show work in making the decision for each criterion.

a) EMV approach.
b) EOL approach.

Advanced Statistics, Statistics

  • Category:- Advanced Statistics
  • Reference No.:- M95382

Have any Question? 

Related Questions in Advanced Statistics

Learning outcomesselect an experimental design appropriate

Learning Outcomes Select an experimental design appropriate to a particular scientific system, create the design matrix and analyse the results. Implement appropriate multivariate techniques using statistical software. C ...

How can internal and external validity be increased in an

How can internal and external validity be increased in an experiment?

Apply holt-winters double exponential smoothing without

Apply Holt-Winters Double exponential smoothing (without seasonality) to forecast the values of sales X for periods 12 and 13, using α = 0.2 and β = 0.3. Assume 12 months of sales data, as shown in the table below:     A ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro