What is the estimated regression equation

Assignment Help Basic Statistics
Reference no: EM132122843

Assignment -

In this assignment MS Excel must be used to perform any calculations/graphical presentations as required in this assignment.

Question 1 - Below you are given the examination scores of 20 students (data set also provided in accompanying MS Excel file).

52

99

92

86

84

63

72

76

95

88

92

58

65

79

80

90

75

74

56

89

a. Construct a frequency distribution, cumulative frequency distribution, relative frequency distribution, cumulative relative frequency distribution and percent frequency distribution for the data set using a class width of 10.

b. Construct a histogram showing the percent frequency distribution of the examination scores. Comment on the shape of the distribution.

Question 2 - Shown below is a portion of a computer output for a regression analysis relating supply (Y in thousands of units) and unit price (X in thousands of dollars).

ANOVA

 

df

SS

Regression

1

354.689

Residual

39

7035.262

 

Coefficients

Standard Error

Intercept

54.076

2.358

X

0.029

0.021

a. What has been the sample size for this problem?

b. Determine whether or not supply and unit price are related. Use α = 0.05.

c. Compute the coefficient of determination and fully interpret its meaning. Be very specific.

d. Compute the coefficient of correlation and explain the relationship between supply and unit price.

e. Predict the supply (in units) when the unit price is $50,000.

Question 3 - Allied Corporation wants to increase the productivity of its line workers. Four different programs have been suggested to help increase productivity. Twenty employees, making up a sample, have been randomly assigned to one of the four programs and their output for a day's work has been recorded. You are given the results below (data set also provided in accompanying MS Excel file).

Program A

Program B

Program C

Program D

150

150

185

175

130

120

220

150

120

135

190

120

180

160

180

130

145

110

175

175

a. Construct an ANOVA table.

b. As the statistical consultant to Allied, what would you advise them? Use a .05 level of significance.

Question 4 - A company has recorded data on the weekly sales for its product (y), the unit price of the competitor's product (x1), and advertising expenditures (x2). The data resulting from a random sample of 7 weeks follows. Use Excel's Regression Tool to answer the following questions (data set also provided in accompanying MS Excel file).

Week

Price

Advertising

Sales

1

.33

5

20

2

.25

2

14

3

.44

7

22

4

.40

9

21

5

.35

4

16

6

.39

8

19

7

.29

9

15

a. What is the estimated regression equation? Show the regression output.

b. Determine whether the model is significant overall. Use α = 0.10.

c. Determine if competitor's price and advertising is individually significantly related to sales. Use α = 0.10.

d. Based on your answer to part (c), drop any insignificant independent variable(s) and re-estimate the model. What is the new estimated regression equation?

e. Interpret the slope coefficient(s) of the model from part (d).

Verified Expert

This assignment is based on the basic concepts of the statistics. In this provided assignment, there are four problems based on the distribution of the frequency and class interval. By using class interval, we have to make the histogram and discuss its shape. Also, the last 3 problems of the assignment, they are based on the linear regression and multiple regression analysis for the various provided data in the last 3 questions of the task.

Reference no: EM132122843

Questions Cloud

Identify and describe the six types of e-commerce : Identify and describe the six types of e-commerce. Give an example for each one.
What are impacts that flexible work schedules : What are impacts that flexible work schedules can have on a employee's productivity?
Satisfaction as well as maintained unmanagement culture : Describe how the sponsor program developed higher levels of employee satisfaction as well as maintained the “unmanagement” culture.
Activities that are associated with the summer olympics : How does global marketing and the use of new digital marketing techniques facilitate marketing activities at the Olympics in Rio?
What is the estimated regression equation : What is the estimated regression equation? Show the regression output - Determine if competitor's price and advertising is individually significantly related
Improve employee retention and engagement : Many rightfully offer IBM as an example of an employer that works hard to improve employee retention and engagement.
Compare the given religions : Write a 525- to 700-word overview of the history of Hinduism, as well as the importance and role of the sacred texts. Include an explanation of the rituals.
Erm strengths and weaknesses of strategy : In the process, the bank gave enormous trading authority to one individual. What are the ERM strengths and weaknesses of this strategy?
What is often true of presenting problems : What is often true of presenting problems? Did you complete your spring break homework.

Reviews

urv2122843

10/24/2018 4:47:57 AM

Extremely satisfied. Your service is really professional, quick, and pay attention to my tasks. Thank you for your cool support, as usual, good job mates. keep going on... You are the best fellows of mine will come back to you again soon. Thank you for your kind support, you are so nice. Thank you for a good job!

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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