Questions 4 and 5 please

This problem set refers to data from PS1_Hamburger.xlsx" found on eCampus. You are a new analyst with 12th Man Consulting, and a local butcher - Aggieland Butcher Shop - has approached you with a problem. Aggieland Butcher Shop (ABS) primarily produces hamburger patties to sell to local restaurants and eateries. ABS wants to purchase a new hamburger patty machine, but doesn't know which machine to buy: Patty-O-Matic 330A, which costs $7,995 Gesame MH-100 Food Former, which costs $9,900 Each machine produces hamburger patties that are 4oz on average, but there is some variability; because the meat is sticky, sometimes the patties are a little over or a little under 4oz. If the produced patty is over 3.99oz, that's fine. However, if the produced patty is under 3.99oz, local restaurants won't buy it, so the small patty is scrapped, and the meat is put back into the machine at a small cost. Aggieland Butcher Shop wants your professional recommendation on which machine to purchase. 1. [10 pts) Columns E, F, and G show 100 observations of the size of patties produced by each machine. Calculate the mean, median, and standard deviation of patty sizes for each machine (random variable) and put your answers in a well-formatted table. 2. [10 pts) Test the equality of variance for produced patties from the machines. Provide your null and alternative hypotheses, and all results from your test. Are the variances equal? (Hint: you should use an F-test) 3. [10 pts) Test the equality of the sample mean patty size for each machine, using a two-sample, two-tailed t-test. Provide your null and alternative hypothesis, and all results from your test. Is the average patty size equal across both machines? (Hint: the t-test is two-sample, but be sure to use the results from (2) to decide whether to assume equal or unequal variances) 4. [10 pts] Using the observed data, what is the daily profit of each machine? How many days will it take to breakeven for each machine? Which machine do you recommend to Aggieland Butcher Shop? 5. [10 pts] Suppose the Patty-O-Matic 330A gets an upgrade that decreases the cost of re-using under-sized patties from $0.25 to $0.11, though the price tag increases from $7,995 to $8,100. How do these changes affect your recommendation? Patty-O-Matic 330A Gesame MH-100 Food Former $ 7,995.00 $ 9,900.00 4.00 4.00 0.03 0.01 16 3.99 0.25$ 16 3.99 0.25 $ ul $ $ $ 2.00 $ 12.00$ 1.50$ 2.00 12.00 1.50 1 2 3 Cost 4 Average Patty Size (oz) 5 Standard Deviation (oz) 6 7 Ounces per pound 8 Minimum patty size 9 Cost if under 10 11 Supply cost (per lb) 12 Fixed Labor Cost 13 Retail Price per patty 14 15 Total Production (oz) 16 Total Production (lbs) 17 18 Cost of production 19 Cost of reused meat 20 Fixed Labor Cost 21 Total Cost per day 22 23 Total Revenue per day 24 25 Total Profit per day 26 27 Days to Break-even 28 29 273.0886901 17.06804313 316.2282917 19.76426823 $ $ $ $ 34.14 $ 8.00 $ 12.00 $ 54.14 $ 39.53 5.25 12.00 56.78 $ 102.00$ 118.50