Determine the correlation coefficient

Assignment Help Applied Statistics
Reference no: EM135290

Problem 1

The average prices for a product in twelve 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 a = 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 given in the table below.

Year

Sales

(thousands of dollars)

Net Profit

1

59

5.0

2

50

8.4

3

51

9.5

4

65

8.6

5

80

1.5

6

85

-2.1

7

95

1.2

8

90

1.8

(a) Make a scatter diagram for the data, 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) Determine the correlation coefficient. Comment on the value of the correlation coefficient.

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

(d) Construct 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 following table:

Day

Sales (Dollars)

1

200

2

250

3

180

4

190

5

175

6

170

7

180

(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 techniques using the Mean Absolute Deviation.

Problem 4

The revenue and cost functions for producing and selling quantity x for a certain company are given below.

                R(x) = 12x - x2

                C(x) = 21 + 2x

(a) Determine the profit function P(x).

(b) Compute the break-even quantities.

(c) Determine the average cost at the break-even quantities.

(d) Determine the marginal revenue R'(x).

(e) Determine 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 shown below.

Item

Price

Cost

Assembly Times (hr)

A

$20

$10

2

B

$45

$20

4

The company will produce 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. Suppose the company has 100,000 hours of assembly time available, how many of each item should it produce in order to maximize profits while meeting all necessary constraints? Give the LP Model and use both the graphical method and Excel to find 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.

 

Demand for Item

Alternative

Low

Medium

High

Do nothing

0

0

0

Order Low

30,000

30,000

30,000

Order Medium

10,000

50,000

40,000

Order High

-10,000

40,000

80,000

Probability

0.3

0.3

0.4

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

a) EMV approach

b) EOL approach

Reference no: EM135290

Questions Cloud

Proposal about decentralization registration : Proposal about decentralization registration in Rustaq general hospital which contained clinics morning shifts only but in emergency department for three shifts.
What rules will develop for supervisors : What rules will you develop for supervisors to successfully respond to employee questions about unionization? What can your supervisors say or else do that is legally permissible in this situation
Examine the organization from several perspectives : For the Leadership Dares, the focus will be on corporations as well as their leaders that have been in crisis. A list of organizations will be delivered below. Examine the organization from several perspectives and analyze the organization using.
Describe how the economic reality test used : What differences and similarities exist regarding how a contingent worker is compensated. Describe how the economic reality test and the right to control tests are used to conclude whether a person is an employee or an independent worker.
Determine the correlation coefficient : Determine the correlation coefficient. Find the predicted value of Y given X = 75. Give an interpretation of the predicted value in the context of the problem.
What do you meant by demand analysis in hr planning : What do you meant by demand analysis in HR planning? Present and show the factors that need to be considered when forecasting demand analysis.
Define culture in your response : Explain the role culture may play in influencing entrepreneurship both at the individual and social level. Define culture in your response.
Service and manufacturing process : Service/ Manufacturing process design is based on a considerable number of different variables and shows, in essence, a number of trade-offs.
Supporting mobile health clinics : Analyze Case Study : Supporting Mobile Health Clinics: The Children's Health Fund of New York City and Examine the case study, and develop the conclusions, recommendations, and implications.

Reviews

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

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