Statistics Analysis

timer Asked: Apr 26th, 2017

Question description

Data set 2 presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. The company’s operations manager believes that the number of defects produced by the process is less than seven defective flash drives per week.

Use Excel’s Analysis ToolPak to compute the regression equation for predicting the number of defective flash drives over time (in weeks), the correlation coefficient r and the coefficient of determination R2.

Submit your statistical output from Excel, which should include values for the

slope, y-intercept, regression equation, r, and R2.

Submit a Word file that includes the hypothesis test. Specifically, the following critical elements must be addressed:





Guidelines for Submission:

Submit a 1-page Word document with spreadsheet..

A finance manager employed by an automobile dealership believes that the number of cars sold in his local market can be predicted by the interest rate charged for a loan. Interest Rate (%) Number of Cars Sold (100s) 3 10 5 7 6 5 8 2 The finance manager performed a regression analysis of the number of cars sold and interest rates using the sample of data above. Shown below is a portion of the regression output. Regression Statistics Multiple R 0.998868 R2 0.997738 Coefficient Intercept 14.88462 Interest Rate -1.61538 Specially, the following critical elements must be addressed; Main elements: • Are there factors other than interest rate charged for a loan that the finance manager should consider in predicting future car sales? Integration and Application: • Is interest rate charged for a loan the most important factor to be considered in predicting future car sales? Explain your reasoning. • The dealership’s vice-president of marketing has requested a sales forecast at the prevailing interest rate of 7%. Analysis: • As finance manager, what reasons would you convey to the vice-president in recommending this forecasting model? Critical Thinking • Is the prediction of car sales at 7% a reflection of the current downturn in the economy? How might this impact the dealership’s business? Analysis of this scenario should be 1-2 page Microsoft word document with double spacing and 12 point Times New Roman font
Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 #Flashdrives 6 7 6 5 7 5 6 6 8 9 9 7 5 6 8 8 9 7 6 8 5 7 6 8 10 9 7 8 7 6 Number of Defective Flashdrives for 30 Weeks Flashdrives for 30 Weeks
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors