1. Produce a scatter plot matrix and interpret it. Produce a correlation matric and confirm your findings in part A. Provide a regression analysis for the following variables Triceps vs Fat Midram vs Fat Thigh vs Fat Predict the body fat of a patient with 26.2 triceps fat electric conductivity e) From the model developed in part c) which model is best to describe the fat content. Explain. Fat Triceps Midarm Thigh 11.9 19.5 29.1 43.1 22.8 24.7 28.2 49.8 18.7 30.7 37 51.9 20.1 29.8 31.1 54.3 12.9 19.1 30.9 42.2 21.7 25.6 23.7 53.9 27.1 31.4 27.6 58.5 25.4 27.9 30.6 52.1 21.3 22.1 23.2 49.9 19.3 25.5 24.8 53.5 25.4 31.1 30 56.6 27.2 30.4 28.3 56.7 11.7 18.7 23 46.5 17.8 19.7 28.6 44.2 12.8 14.6 21.3 42.7 23.9 29.5 30.1 54.4 22.6 27.7 25.7 55.3 25.4 30.2 24.6 58.6 14.8 22.7 27.1 48.2 21.1 25.2 27.5 51 2. Farris Billiard Supply sells all types of billiard equipment, and is considering manufacturing their own brand of pool cues. Mysti Farris, the production manager, is currently investigating the production of a standard house pool cue that should be very popular. Upon analyzing the costs, Mysti determines that the materials and labor cost for each cue is $25, and the fixed cost that must be covered is $2,400 per week. With a selling price of $40 each, how many pool cues must be sold to break even ? What would the total revenue be at this breakeven point ? a. Mystic Farris is considering raising the selling price of each cue to $50 instead of $40. If this is done while the cost remain the same, what is would the new break-even point be? What would the total revenue be at this beak-even point? b. Mysti Farris believes that there is a high probability that 120 pool cues can be sold if the selling price is appropriately set. What selling price would cause the break-even point to be 120? 3. Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. A French Provincial model require 2 man hours for cutting, 1 man hour for shaping and 3 man hours for finishing while a Danish Modern model requires 2 man hours for cutting, 2 man hours for shaping 1 man hour for finishing. Each day the company has available 140 man hours for cutting, 120 man hours for shaping and 150 man hours for finishing. The company would like to determine a product mix to maximize their profits. Assume a French Provincial mode yields a profit of $10 and a Danish modern model yields a profit of $8. a. Formulate as an linear programming (LP) problems b. Solve using graphical method. c. confirm your results using excel solver.

1. Produce a scatter plot matrix and interpret it. Produce a correlation matric and confirm your findings in part A. Provide a regression analysis for the following variables Triceps vs Fat Midram vs Fat Thigh vs Fat Predict the body fat of a patient with 26.2 triceps fat electric conductivity e) From the model developed in part c) which model is best to describe the fat content. Explain. Fat Triceps Midarm Thigh 11.9 19.5 29.1 43.1 22.8 24.7 28.2 49.8 18.7 30.7 37 51.9 20.1 29.8 31.1 54.3 12.9 19.1 30.9 42.2 21.7 25.6 23.7 53.9 27.1 31.4 27.6 58.5 25.4 27.9 30.6 52.1 21.3 22.1 23.2 49.9 19.3 25.5 24.8 53.5 25.4 31.1 30 56.6 27.2 30.4 28.3 56.7 11.7 18.7 23 46.5 17.8 19.7 28.6 44.2 12.8 14.6 21.3 42.7 23.9 29.5 30.1 54.4 22.6 27.7 25.7 55.3 25.4 30.2 24.6 58.6 14.8 22.7 27.1 48.2 21.1 25.2 27.5 51 2. Farris Billiard Supply sells all types of billiard equipment, and is considering manufacturing their own brand of pool cues. Mysti Farris, the production manager, is currently investigating the production of a standard house pool cue that should be very popular. Upon analyzing the costs, Mysti determines that the materials and labor cost for each cue is $25, and the fixed cost that must be covered is $2,400 per week. With a selling price of $40 each, how many pool cues must be sold to break even ? What would the total revenue be at this breakeven point ? a. Mystic Farris is considering raising the selling price of each cue to $50 instead of $40. If this is done while the cost remain the same, what is would the new break-even point be? What would the total revenue be at this beak-even point? b. Mysti Farris believes that there is a high probability that 120 pool cues can be sold if the selling price is appropriately set. What selling price would cause the break-even point to be 120? 3. Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. A French Provincial model require 2 man hours for cutting, 1 man hour for shaping and 3 man hours for finishing while a Danish Modern model requires 2 man hours for cutting, 2 man hours for shaping 1 man hour for finishing. Each day the company has available 140 man hours for cutting, 120 man hours for shaping and 150 man hours for finishing. The company would like to determine a product mix to maximize their profits. Assume a French Provincial mode yields a profit of $10 and a Danish modern model yields a profit of $8. a. Formulate as an linear programming (LP) problems b. Solve using graphical method. c. confirm your results using excel solver.