i want to solve this using excel

D An economist wants to estimate the mean monthly family expenditure on food items. He assumes the standard deviation of the monthly expenditure to be $350. How many families need to be sampled to estimate the mean monthly family expenditure on food items to within a sampling error of +$20 with 90% confidence? 2 A financial analyst is analyzing the mean credit card debt incurred by senior students of universities across Germany. She determines that the mean credit card debt for a senior is 4,600. However, based on the student council report from Dortmund University in Germany, the credit card debt for a senior is less than 4,600. The financial analyst selects a random sample of 50 seniors, and determines the mean debt is 4.201 with a population standard deviation of 1,500. a. At the 0.01 significance level, is there evidence that the mean amount is different from 4,600? b. Compute the T. value and use it to draw a conclusion for the financial analyst at a 1% significance level. c. Construct a 99% confidence interval estimate of the population mean amount of credit card debt. d. What conclusions do you reach based on the result of (c)? Compare it with the result in (a). a Starbucks Coffee Co, uses a data-based approach to improve the quality and customer satisfaction of its products. When survey data indicated that Starbucks needed to improve its package-scaling process, an experiment was conducted to determine the factors in the bag-sealing equipment that might be affecting the ease of open- ing the bag without tearing the inner liner of the bag. Source: Data extracted from L. Johnson and S. Burrows, "For Starbucks, It's in the Bag." Quality Progress, March 2011, pp. 17-23. One factor that could affect the rating of the ability of the bag to resist tears was the plate gap on the bag-sealing equipment. Data were collected on 19 bags in which the plate gap was varied. The results are stored in Starbucks a. Construct a scatter plot. b. Assuming a linear relationship, use the least-squares method to determine the regression coefficients b, and by c Interpret the meaning of the slope, bl, in this problem. d. Predict the mean tear rating when the plate gap is equal to 0. e. What should you tell management of Starbucks about the rela- tionship between the plate gap and the tear rating? 40 murks Tear Viscosity Pressure 0.00 350.00 180.00 0.00 350.00 170.00 0.45 319.00 186.00 0.85 380.00 174.00 0.35 350.00 180.00 0.30 300.00 180.00 0.70 400.00 180.00 1.90 350.00 190.00 0.25 350.00 180.00 0.10 319.00 186.00 0.15 380.00 186.00 3.90 350.00 180.00 0.00 380.00 174.00 0.55 350.00 180.00 0.00 350.00 180.00 0.05 319.00 174.00 0.40 319.00 174.00 4.30 380.00 186.00 0.00 350.00 180.00 Plate Gap 0.00 0.00 1.80 1.80 0.00 0.00 0.00 0.00 0.00 -1.80 -1.80 3.00 -1.80 0.00 -3.00 -1.80 1.80 1.80 0.00