PLEASE ONLY ANSWER WITY EXCEL FORMULAS AND WORK

[xZ2n,x+Z2n] [xt2ns,x+t2ns] Chapter 9 [Part I \& Part II]: A company that produces and markets video game systems wishes to assess its customers' level of satisfaction with a relatively new model, the XYZ-Box. In the six months since the introduction of the model, the company has received 73,219 warranty registrations from purchasers. The company will randomly select 65 of these registrations and will conduct telephone interviews with the purchasers. Specifically, each purchaser will be osked to state his or her level of agreement with each of the seven statements listed on the survey instru. Git given in Figure 1.6. Here, the level of agxeement for each statement is measured on a 7-point Likert scale. Purchaser satisfaction will be measured by adding the purchaser's responses to the seven statements. It follows that for each consumer the minimum composite score possible is 7 and the maximum is 49 . When the 65 customers are interviewed, their composite scores are as stored in the "VideoGame" data file. The company approximates that the standard deviation of the population of all ratings is =2.74, while the value is unknown. Part a. Explain how the CLT conditions are met here. Part b. Part c Using the NORM.S.INV function, revisit Part b. Part d. Using the CONFIDENCE.T function, revisit Part b where is unknown. Part e. Using the TINV function, revisit Part b where is unknown. [xZ2n,x+Z2n] [xt2ns,x+t2ns] Chapter 9 [Part I \& Part II]: A company that produces and markets video game systems wishes to assess its customers' level of satisfaction with a relatively new model, the XYZ-Box. In the six months since the introduction of the model, the company has received 73,219 warranty registrations from purchasers. The company will randomly select 65 of these registrations and will conduct telephone interviews with the purchasers. Specifically, each purchaser will be osked to state his or her level of agreement with each of the seven statements listed on the survey instru. Git given in Figure 1.6. Here, the level of agxeement for each statement is measured on a 7-point Likert scale. Purchaser satisfaction will be measured by adding the purchaser's responses to the seven statements. It follows that for each consumer the minimum composite score possible is 7 and the maximum is 49 . When the 65 customers are interviewed, their composite scores are as stored in the "VideoGame" data file. The company approximates that the standard deviation of the population of all ratings is =2.74, while the value is unknown. Part a. Explain how the CLT conditions are met here. Part b. Part c Using the NORM.S.INV function, revisit Part b. Part d. Using the CONFIDENCE.T function, revisit Part b where is unknown. Part e. Using the TINV function, revisit Part b where is unknown