please answer using detailed calculatio. (excel)

Hypothesis test a population variance 1) A manufacturing firm has been working diligently to implement a just-in-time inventory system for its production line. The final product requires the installation of a pneumatic tube at a particular station on the assembly line. With the just in time Inventory system, the company's goal is to minimize the number of pneumatic tubes that are piled up at the station waiting to be installed. Ideally, the tubes would arrive just as the operator needs them. However, because of the supplier and the variables involved in getting the tubes to the line, most of the time there will be some buildup of tube inventory. However, the production superintendent want the variance of this Inventory no more than 4. number of tubes are recorded. 17 20 29 21 14 19 24 a) Formulate the null and alternative hypotheses b) Compute the sample variance c) Using 95% confidence interval, develop interval estimation d) Test the hypothesis using p-value and critical value approach , a = 0,05 e) What is your conclusion