You are provided with a summary table that lists causes of laptop warranty cases at an electronics repair shop. You are tasked with identifying the causes that contribute the most to the problem of warranty issues. You are also asked to identify if there is a relationship between the frequency of the causes and the repair costs. IN EXCEL WITH THE FUNCTIONS$/$EQUATIONS SHOWN PLEASE.Prompt:

You are provided with a summary table that lists causes of laptop warranty cases at an electronics repair shop. You are tasked with

identifying the causes that contribute the most to the problem of warranty issues. You are also asked to identify if there is a relationship

between the frequency of the causes and the repair costs.

Questions:

a$)$ Compute the Coefficient of Correlation

Analysis.

b$)$ Create a SCATTER PLOT that shows the value for R$2.$

c$)$ Based on the correlation coefficient $r$ and the

result of the scatter plot, how would you

describe the relationship between the

frequency of warranty causes and their repair

$0\mathrm{.}0\%0\mathrm{.}0\%0\mathrm{.}0\%0\mathrm{.}0\%0\mathrm{.}0\%0\mathrm{.}0\%$

e$)$ Based on the Pareto chart, what are

the most important causes of warranty

issues that need to be addressed.

Explain why$/$how you identified these

causes.

Cause Cost of Repair in Dollars Cause Frequency

Physical Damage $$788,92$

Motherboard $$480,81$

Screen $$175,37$

Power Cord $$250,25$

Keyboard $$170,22$

Graphic Card $$250,19$

Cooling Fans $$80,15$

Total $$2193,291$

a$)$Compute the Coefficient of Correlation Analysis.

B$)$Create a SCATTER PLOT that shows the value for R$2.$

C$)$Based on the correlation coefficient r and the result of the scatter plot, how would you describe the relationship between the frequency of warranty causes and their repair cost?

D$)$Create a PARETO CHART based on the cause frequency.

e$)$ Based on the Pareto chart, what are the most important causes of warranty issues that need to be addressed. Explain why$/$how you identified these causes.