country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

HI6007 Statistics For Business Decision

tag 0 Download4 Pages 970 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question 1 

Below you are given the examination scores of 20 students  

52

99

92

86

84

63

72

76

95

88

92

58

65

79

80

90

75

74

56

99

 
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 widthof
 
b. Construct a histogram showing the percent frequency distribution of the examination scores. Comment on the shape ofthe  

Question

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  

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

 

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.

 

e.

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? 

 

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

 

 

Answer 1

a. Frequency descriptions
 
 

 

 

 

 

 

 

Examination Score

Frequency distribution

Cumulative Frequency

Relative Frequency

Cumulative relative Frequency

Percent Frequency

50-60

3

3

0.15

15%

15%

 

60-70

2

5

0.10

25%

10%

 

70-80

6

11

0.30

55%

30%

 

80-90

4

15

0.20

75%

20%

 

90-100

5

20

0.25

100%

25%

 

Total

20

 

 

 

 

 

b. Construction of the histogram

 

The examination score between the range of 70-80 is responsible for 30% of the total scores. This means the range 70-80 is the modal class range.

Answer 2

  1. Suppose the sample size is denoted by n and the number of regressions by k. by observing the regression output availed, k is given as 1. Being that

       We can obtain , this gives us the value of n as 41

       The sample size is therefore obtained as 41.

  1. For x and y to be correlated, the coefficient of x must be a value other than zero.

For this reason, will test the hypothesis that the coefficient

Our hypothesis is therefore defined as

vs

The value of

The rejection rule is; reject the null hypothesis whenever the p value is less than the value of alpha.

Now we compute the p value

SSR

354.689

SSE

7035.262

df Regression

1

df Error

39

F statistic

1.96622

p value

0.16876

The value is obtained as 0.16876, which is greater than alpha which is 0.05. we thereby fail to reject the null hypothesis.

We thereby conclude that there is sufficient evidence from the sample to prove that the coefficient of x is 0, this indicates that the values of x and y are not correlated.

  1. The coefficient of determination will be obtained as 0 given that the two variables (x and y0 are independent of each other.
  2. The coefficient of correlation is obtained as 0 given that the coefficient of determination is 0. This shows indecency among the two variables.
  3. The output given can be used to derive the linear equation relating x and y as;

Fromm this equation we can substitute the value of x with 50000 and obtain the number of units as

 

Answer 3

  1. Construction of the ANOVA table

Anova: Single Factor

 

 

 

 

 

SUMMARY

 

 

 

 

 

 

Groups

Count

Sum

Average

Variance

 

 

Program A

5

725

145

525

 

 

Program B

5

675

135

425

 

 

Program C

5

950

190

312.5

 

 

Program D

5

750

150

637.5

 

 

ANOVA

 

 

 

 

 

 

Source of Variation

SS

df

MS

F

P-value

F crit

Between Groups

8750

3

2916.666667

6.140351

0.00557

3.238872

Within Groups

7600

16

475

 

 

 

Total

16350

19

 

 

 

 

 

  1. Discussion and Recommendation

Suppose

The task needs the conduction of a hypothesis

 vs at least one of the means is difference.

The

The p value is obtained from the excel output as 0.00557, compared to the value of

Alpha  this falls in the rejection region hence we reject the

Null hypothesis and conclude that the evidence indicates at least one of the means is

Difference.

The Advice to the Allied corporation is that there is a statistical difference among the

Outputs that arise from the workers under the difference. The firm therefore need to

specialise in the program that generates optimum output. This is specifically program

C.

Answer 4

  1. Regression equation

Display of the multiple regression output

SUMMARY OUTPUT

 

 

 

 

 

 

 

Regression Statistics

 

 

 

 

 

 

 

Multiple R

0.877814

 

 

 

 

 

 

 

R Square

0.770558

 

 

 

 

 

 

 

Adjusted R Square

0.655837

 

 

 

 

 

 

 

Standard Error

1.83741

 

 

 

 

 

 

 

Observations

7

 

 

 

 

 

 

 

ANOVA

 

 

 

 

 

 

 

 

 

df

SS

MS

F

Significance F

 

 

 

Regression

2

45.35284447

22.67642

6.716801

0.052644

 

 

 

Residual

4

13.50429839

3.376075

 

 

 

 

 

Total

6

58.85714286

 

 

 

 

 

 

 

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 90.0%

Upper 90.0%

Intercept

3.597615

4.052243833

0.887808

0.424805

-7.65322

14.84845

-5.04115

12.23638

Price

41.32002

13.33736254

3.098065

0.036289

4.289567

78.35048

12.88681

69.75324

Advertising

0.013242

0.327591655

0.040422

0.969694

-0.8963

0.922782

-0.68513

0.711617

The output can be used to derive the linear equation:

  1. The significance of the model is given as 0.0526 which is less than the value of alpha (0.10). the conclusion is thus the model is statistically significant.
  2. The competitors price p value is obtained from the model as 0.0362, this is lower than the alpha value hence the price can be stated to be statistically significant to the sales values.

Meanwhile the alpha value for advertising is given from the model as 0. l9697 which is higher than the value of alpha. Advertising is therefore not statistically significant to the sales value.

  1. Revised regression model

SUMMARY OUTPUT

 

 

 

 

 

 

 

 

Regression Statistics

 

 

 

 

 

 

 

Multiple R

0.877760967

 

 

 

 

 

 

 

R Square

0.770464315

 

 

 

 

 

 

 

Adjusted R Square

0.724557178

 

 

 

 

 

 

 

Standard Error

1.643764862

 

 

 

 

 

 

 

Observations

7

 

 

 

 

 

 

 

ANOVA

 

 

 

 

 

 

 

 

 

df

SS

MS

F

Significance F

 

 

 

Regression

1

45.34732824

45.34732824

16.7831053

0.009384894

 

 

 

Residual

5

13.50981461

2.701962923

 

 

 

 

 

Total

6

58.85714286

 

 

 

 

 

 

 

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 90.0%

Upper 90.0%

Intercept

3.581788441

3.608215389

0.992675895

0.366447177

-5.693424497

12.85700138

-3.688940109

10.85251699

Price

41.60305344

10.15521323

4.096718846

0.009384894

15.49824676

67.70786011

21.13980753

62.06629934

This model generates the linear equation;

  1. The model has a slope of 41.60 which indicates that a unit increase in the price of the competitors goods raises the sales volume by 41.60 units.
 

References

Andrew, G., 2008. Variance, analysis of. The new Palgrave dictionary of economics. 2nd ed. Basingstoke, Hampshire New York: Palgrave Macmillan.

Bailey, R. A., 2008. Design of Comparative Experiments, s.l.: Cambridge University Press.

Klaus, H. & & Oscar, K., 2008). . Design and Analysis of Experiments. I and II ed. s.l.:Wiley.

Scott, J. A., 2012. Illusions in Regression Analysis. International Journal of Forecasting, 28(3), p. 689.

Willem, W., Baets, D. & Luc, B., 2008. ROC analysis in ordinal regression learning. Pattern Recognition Letters, Volume 29, p. 1–9.

OR

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2019). Statistics For Business Decision. Retrieved from https://myassignmenthelp.com/free-samples/hi6007-statistics-for-business-decision.

"Statistics For Business Decision." My Assignment Help, 2019, https://myassignmenthelp.com/free-samples/hi6007-statistics-for-business-decision.

My Assignment Help (2019) Statistics For Business Decision [Online]. Available from: https://myassignmenthelp.com/free-samples/hi6007-statistics-for-business-decision
[Accessed 22 January 2020].

My Assignment Help. 'Statistics For Business Decision' (My Assignment Help, 2019) <https://myassignmenthelp.com/free-samples/hi6007-statistics-for-business-decision> accessed 22 January 2020.

My Assignment Help. Statistics For Business Decision [Internet]. My Assignment Help. 2019 [cited 22 January 2020]. Available from: https://myassignmenthelp.com/free-samples/hi6007-statistics-for-business-decision.


Get your urgent essay or other academic papers written by the best writers from the most reliable writing services - MyAssignmenthelp.com. We offer a wide range of writing services for essays of all genres that includes persuasive essay, compare essay and contrast essay, narrative essay, argumentative essay and many more. Students who lack the flair for writing essays can also check our repository of samples for free to learn how to write a narrative/persuasive/descriptive essay.

Latest Statistics Samples

HI6008-Quality Of Financial Reporting

Download : 0 | Pages : 10

Answer:  Introduction In the past decade, the conceptual framework in Accounting and Quality of Financial Reporting has become a vital aspect in accounting and management of financial reporting system of organization. Without a useful conceptual framework, organizations face challenges in the maintainer of the financial reports. The conceptual framework in accounting and quality financial reporting was developed to guide users and prepar...

Read More arrow

MGT723 Research Project 3

Downloads : 3 | Pages : 12

Answer: Data Analysis Descriptive Statistics Frequencies In terms of the whether incentive was provided by the company, 52.6% (n = 66) of the chosen companies said to provide incentives for the management of climate change issues, including the attainment of targets while 47.4% (n = 27) did not provide incentives. As can be seen, it is evident that there is no statistically significant association between type of company and offering incenti...

Read More arrow

ITECH7405-Analysis Of Air Traffic Passenger Movement Data

Download : 0 | Pages : 3

Answer: Introduction We started the project with the clear objective of analyzing air transport data to discover trends and patterns to help various stakeholders in decision making. This objective was realized since relevant data was gathered through secondary sources and oral interviews an analysis was done, results were documented and recommendations made. The whole project was framed in a way that the various stakeholders will be able to u...

Read More arrow

STAT101 Statistics

Downloads : 2 | Page : 1

Answer: 1. Given data points   Frequency distribution   Class interval Frequency Relative frequency 12 – 16 6 0.30 17- 21 3 0.15 22 -26 7 0.35 27-31 3 0.15 32 -36 1 0.05 Total 20 1   Relative Frequency = Class frequency/Total Observations 2. Frequency table   Histogram ...

Read More arrow

QMTH104 Quantitative Methods

Downloads : 2 | Pages : 8
  • Course Code: QMTH 104
  • University: Kent Institute Australia
  • Country: Australia

Answer: Introduction This report emphasizes on the analysis of the expenditure patterns of international students in Australia. For this purpose, there is a need to collect the relevant information from the international students visited or residing in Australia to pursue their studies. The target population consists of the international students residing in Australia in order to gather information regarding their expenditure patterns. The ma...

Read More arrow
Next
watch

Save Time & improve Grades

Just share your requirements and get customized solutions on time.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,183,360

Orders

4.9/5

Overall Rating

5,057

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

529 Order Completed

95% Response Time

Ivan Blank

PhD in Functional Human Biology

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

134 Order Completed

95% Response Time

Thomas Nelson

MS in Information Systems Technology with Specialization in Database Administration

New Jersey, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

154 Order Completed

97% Response Time

Harold Alderete

PhD in Economics

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

416 Order Completed

95% Response Time

Tyler Moore

MBA in Accounting

Washington, United States

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Everything I ask for they deliver. Great website to use for all writing assignments!

flag

User Id: 365326 - 21 Jan 2020

Australia

student rating student rating student rating student rating student rating

bad work and unfocused tutor and not smart people that make you to deliver work not related to my order, i missed the deadline because of you horrible

flag

User Id: 353499 - 21 Jan 2020

Australia

student rating student rating student rating student rating student rating

I was hoping to get a better grade, but I\'m fine with what I got, and did not end up with just a barely passing grade. Thank you for your cooperation!

flag

User Id: 94698 - 21 Jan 2020

Australia

student rating student rating student rating student rating student rating

Thank you for your help. I will ask for more help from your team. ........................

flag

User Id: 364056 - 21 Jan 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?