2 A brewery makes light beer and dark beer. 3 It has limited supply of barley, and a limited bottling capacity. 4 The ma
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
2 A brewery makes light beer and dark beer. 3 It has limited supply of barley, and a limited bottling capacity. 4 The ma
2 A brewery makes light beer and dark beer. 3 It has limited supply of barley, and a limited bottling capacity. 4 The market for Dark Beer is limited to 1250 bottles and the company is contracted to supply atleast 500 bottles of Light Beer. 5 The following table shows the resource availabilty and profit per bottle. 6 How many bottles of each product should be produced to maximize profit? 7 Use LP to solve the problem. The solver dialog box must be populated when I open your submission. 8 Download the answer report. 9 It is suggested though not required that you also write down the objective function and constraints. This will help me give you partial credit if the solve 10 11 12 13 14 15 16 17 Resource Barley (grams) Bottling (bottle) Profit (per bottle) Light Beer 0.1 1 $0.20 Resource Availability Dark Beer (per month) 0.6 1 $0.50 2000 6000
Questions Indicted on the left is a dataset indicating HwyMPG, Engine Displacement and Class Size. Regresssion output for 1 & 2 should be on separate sheets. Regression 1 a. Run a regression that can be used to predict the fuel efficiency (Hwy MPG) for highway driving using ONLY the engine's displacement as a variable. b. Come up with a regression equation. c. Is the model significant at 0.05 significance level? Give reasons. Regression 2 d. Now consider adding Class as a variable to the simple linear regression developed in (a) and run the regression with the dummy variable included in the model. e. Come up with a regression equation. f. Which of the independent variables are significant? Give reasons. g. Given that a car is Large and has a dispalcement of 3.6, what would be its HwyMPG? (show working) h. Between the models developed in (a) and (d), which is the better model? Give reason.
D186 5 67 co 222 Undo 22 23 A 10 11 12 7 13 8 14 9 15 10 16 11 17 12 18 13 19 14 20 15 21 16 17 18 24 19 25 30 Car 1 2 3 4 5 6 P Clipboard B 17 D X✓ fx C Engine Displacement Class Compact Compact Compact Compact Compact Compact Compact Compact Compact Compact Compact Compact Compact Compact Compact Compact Compact Compact Compact PH Q9- Regression co 3.1 3.1 № m 3 3 3 3 2.4 3.5 3 2 2.4 2.8 2.5 35 2.5 2.4 5.3 6 3.5 3.5 2.5 H Hwy MPG 25 25 25 25 25 25 25 25 25 24 24 24 22222 + Ic 24 24 24 24 24 220 24 24 24 010-LP Font