Defective Flash Drives: Correlation and Regression Analysis

Methodology

The data of the number of defective flash drives manufactured by a small manufacturing company was obtained by counting them weekly for 30 weeks and then recorded against each week as presented in the Excel file. The Analysis Toolpak of MS Excel in performing correlation and regression analyses. According to Black (2009), correlation and regression analyses require variables to be on a continuous scale. The correlation coefficient (r) was used in interpreting the strength and the nature of the relationship between time and defective flash drives while R-square (R2) was used in predicting the influence of time on the number of defective flash drives. Moreover, the regression equation was formulated using the y-intercept and correlation coefficient.

We will write a
custom essay
specifically for you

for only $16.05 $11/page
308 certified writers online
Learn More

Analysis

The correlation table indicates that there is a moderate relationship between time (week) and the number of defective flash drives, r = 0.303.

Table 1: Correlation.

Week #Defective Flash Drives
Week 1
#Defective Flash Drives 0.303 1

The regression analysis shows that time (week) explains 9.2% of the variation in the number of defective flash drives (R2 = 0.092).

Table 2: Regression.

Multiple R 0.303
R Square 0.092
Adjusted R Square 0.059
Standard Error 1.335
Observations 30

Sharma (2012) asserts that the ANOVA table determines if a regression model is statistically significant or not in predicting the relationship between variables. The ANOVA table reveals that the regression model is not statistically significant in predicting the influence of time (week) on the number of defective flash drives, F(1,28) = 2.831, p = 0.104.

Table 3: ANOVA.

Get your
100% original paper
on any topic

done in as little as
3 hours
Learn More
df SS MS F Significance F
Regression 1 5.047 5.047 2.831 0.104
Residual 28 49.920 1.783
Total 29 54.967

The table of coefficients (Table 4) shows that the y-intercept is 6.299 and the gradient of time is 0.047, which forms the regression equation. In this view, the regression equation is that the number of defective flash drives = 0.047(week) + 6.299. The gradient indicates that a unit change in the dependent variable results in a change of the dependent variable by the gradient coefficient (Sharpe, De Veaux, & Velleman, 2015). Therefore, the regression equation implies that an increase in time by a week results in an increase in the number of defective flash drives by 0.047.

Table 4: Coefficients.

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 6.299 0.500 12.597 0.000 5.275 7.323
Week 0.047 0.028 1.682 0.104 -0.010 0.105

References

Black, K. (2009). Business Statistics: Contemporary Decision Making. New York: John Wiley & Sons.

Sharma, J. K. (2012). Business statistics. New Delhi: Dorling Kindersley.

Sharpe, N., De Veaux, R., & Velleman, P. (2015). Business Statistics. New York: Pearson Education.

Print Сite this

Cite this paper

Select style

Reference

StudyCorgi. (2020, November 4). Defective Flash Drives: Correlation and Regression Analysis. Retrieved from https://studycorgi.com/defective-flash-drives-correlation-and-regression-analysis/

Work Cited

"Defective Flash Drives: Correlation and Regression Analysis." StudyCorgi, 4 Nov. 2020, studycorgi.com/defective-flash-drives-correlation-and-regression-analysis/.

1. StudyCorgi. "Defective Flash Drives: Correlation and Regression Analysis." November 4, 2020. https://studycorgi.com/defective-flash-drives-correlation-and-regression-analysis/.


Bibliography


StudyCorgi. "Defective Flash Drives: Correlation and Regression Analysis." November 4, 2020. https://studycorgi.com/defective-flash-drives-correlation-and-regression-analysis/.

References

StudyCorgi. 2020. "Defective Flash Drives: Correlation and Regression Analysis." November 4, 2020. https://studycorgi.com/defective-flash-drives-correlation-and-regression-analysis/.

References

StudyCorgi. (2020) 'Defective Flash Drives: Correlation and Regression Analysis'. 4 November.

Copy to clipboard

This paper was written and submitted to our database by a student to assist your with your own studies. You are free to use it to write your own assignment, however you must reference it properly.

If you are the original creator of this paper and no longer wish to have it published on StudyCorgi, request the removal.

Psst... Stuck with your
assignment? 😱
Susan
Online
Psst... Stuck with your assignment? 😱
Do you need an essay to be done?
Yes
What type of assignment 📝 do you need?
Yes
How many pages (words) do you need? Let's see if we can help you!
Yes