i want to solve this questions using excel

O 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? a 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? S) b. Compute the Tz value and use it to draw a conclusion for the b. 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 Causes a database improve the quality and customer satisfaction of its products When curvey data indicated that Starbucks needed in process, an experiment was conducted Tac the bag-sealing equipment that might be affecting the Open ing the bag without tearing the inner line of the buy Sowwe Dar et ander Bag Owly Progress MAR 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 hy and c. Interpret the meaning of the slope, by, 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? 4sarks TI 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 430 350.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