4. Determine the Descriptive Statistics (Mean, Mode, Median, Variance, Standard Deviation, First and Third Quartiles, etc…..) for all 9 variables. Comments on your findings.

5. Use PivotTables to find the average for each of the numerical variables for 9 cereal brands of your choice. What conclusions might you reach from calculating the average of each nutrition facts for those selected cereal brands.

6. Randomly select 30 Cereal Brands as your samples. Describe your sampling method.

7. Determine the Descriptive Statistics and compare them to the population parameters found in step 4. Comments on your findings.

8. Use the appropriate formula for confidence interval and find 90%, 95%, and 99% confidence intervals for the mean of Calories, Sugar, and Sodium data.

9. Use regression analysis to find the best model that explains the relationship between calories and the other dependent variables. Interpret all key regression results, hypothesis tests in the output.

From Chapter 4 Case Study 2- An Introduction to Management Science- A Qualitative Approach to Decision Making 14e

Schneider's sweet shop specializes in homade candies and ice cream. Schneider produces its ice cream in-house, in batches of 50 pounds. The first stage in ice cream making is blending of the ingredients to obtain a mix which meets pre-specified requirements on the percentages of certain constituents of the mix. The desired composition is as follows

1. Fat 16%

2. Serum Solids 8%

3. Sugar Solids 16%

4. Egg Solids .35%

5. Stabalizer .25%

6. Emulsifier .15%

7. Water 59.25 %

The mix can be composed from the following list

Ingredient Cost ($/lb)

1. 40% Cream 1.19

2. 23% Cream .70

3. Butter 2.32

4.Plastic Cream 2.30

5. Butter Oil 2.87

6. 4% milk .25

7. Skim condensed milk .35

8. Skim milk powder .65

9. Liquid Sugar .25

10. Sugared frozen fresh egg yolk 1.75

11. Powdered egg yolk 4.45

12. Stabalizer 2.45

13. Emulsifier 1.68

14. Water .00

The number of pounds of a constituent found in a pound of an ingredient is show before. Note that a pound of stabalizer contributes only to the stabalizer requirement (one pound), and that water contributes only to the water requirement (one pound.)

Constituent Ingredient

PRIVATE 1 2 3 4 5 6 7 8 9 10 11 12 13 14

1 .4 .2 .8 .8 .9 .1 .5 .6

2 .1 .1 .3 .1

3 .7 .1

4 .4 .4

5 1

6 1

7 .5 .8 .2 .1 .1 .8 .7 .3 1

Young Jack Schneider has recently acquired the shop from his father. Jack's father has in the past used the following mixture: 9.73 pounds of plastic cream, 3.03 pounds of skim milk powder, 11.37 pounds of liquid sugar,. 44 pounds of sugared frozen fresh egg yolk, .12 pounds of stabalizer, .07 pounds of emulsifier, and 25.24 pounds of water. (The scale at Schneider's is only accurate to 100th of a pound). Jack feels that perhaps it is possible to produce the ice cream in a more cost-effective manner. He would like to find the cheapest mix for producing a batch of ice cream, which meets the requirements specified above. Jack is also curious about the cost effect of being a little more flexible in the requirements listed above. He wants to konw the cheapest mix if the composition meets the following tolerances:

1) Fat 15-17%

2) Serum Solids 7-9%

3) Sugar Solids 15.5-16.5%

4) Egg Solids .3-.4%

5) Stabalizer .2-.3%

6) Emulsifier .1-.2%

7) Water 58-59.5%

Managerial Report

Write a managerial report which compares the cost of Papa Jack's approach to (a) cost-minimized approach using the desired composition (b) the cost-minimized approach with the more flexible requirements. Include in your report the following:

1) The cost of 50 pounds of ice cream under each of the three approaches

2) The amount of each ingredient used in the mix for each of the thre approaches

3) A recommendation as to whcih approach should be used

5.

a. In a Lineweaver-Burk plot, the y-intercept of the line of best fit is equal to _____ and the x-intercept of the line of best fit is equal to _____:

1) 1/V_max ; –1/K_m                                                                                             4) –1/K_m ; V_max

2) 1/K_m ; 1/V_max                                                                                              5) V_max ; K_m     

3) 1/V_max ; –K_m

b. All of the following statements are true about the relationships between [S], K_m, V_o, and V_max EXCEPT:

1) As [S] increases, V_o gets closer to V_max

2) V_max occurs when the enzyme is saturated with substrate

3) K_m is the [S] at which V_o = V_max/2

4) V_o is closest to V_max when [S] is less than K_m

c. When a protein needs to be degraded by the proteasome, it is covalently attached to another protein called _______. The final enzyme in the process that attaches these two proteins to one another is called _______.

1) Ubiquitin; ubiquitin ligase

2) Ubiquitin-activating enzyme; ubiquitin carrier protein                                     

3) Ubiquitin carrier protein; ubiquitin-activating enzyme                        

4) Proteasome; ubiquitin ligase

5) None of the above

d. If an enzyme has a V_max of 60 nM/sec, what is the V_o if the substrate is present at a concentration equal to 3K_m?

1) 12 nM/sec                                                                                      4) 180 nM/sec

2) 45 nM/sec                                                                                     5) Cannot be determined from information given

3) 60 nM/sec                         

e. The pH at which a protein is usually least soluble is equal to

1) 1                                                      

2) 7                                                     

3) The pH at which the protein charge is most negative

4) The isoelectric point (pI) of the protein

5) pKa of the main chain –COOH group

... sleep deprivation influences aggression. To test this assumption, volunteer participants were randomly assigned to sleep-deprivation periods of 0, 24, 48, and 72 hours and subsequently tested for aggressive behavior in a controlled social setting. Aggressive scores signify the total number of different aggressive behaviors, such as "put downs", arguments, or verbal interruptions, that were demonstrated by subjects during the test period. Compute the appropriate test to determine if sleep deprivation has an effect on level of aggression.

• What is your computed answer?
• What probability level did you use and why?

What is the F statistic to test for a difference in mean THC yield between the control and heat-treated seeds?

31.          Strategy is

                1. a central complex secret               2. A staff responsibility       

                3. A tactical weapon

                4.a unifying definition of the business            5. Defined by financial goals

32.          Synergy often results in cost saving from

                1. Layoffs               2. The Value proposition   3. Corporate creativity        

                4. Ethical sensitivity                             5. Customer reduction

                                                              \                                                               

Mark Smith was the Widget division manager.     His was the largest of 5 divisions of International Widgets and Things. The other divisions made parts his division used or used his widgets to make more complex products. A major African supplier was the sole source of an essential raw material. This supplier was attacked by terrorists. Mark was not sure he could maintain his widget’s unique broad market quality appeal without the materials from Africa. The Marketing manager suggested that a new group of consumers could be reached by the internet who would buy widgets without the African materials if they could be made the cheapest in the industry. (Us this case to answer Questions 33-37)

33.          The internet in this case creates a

                1. buyer                 2. low Barrier to entry        3. Channel

                4. Related              5. Substitute

34.          The African supplier would be in the Porter model

                1. a buyer              2. A segment         3. Powerful

                4. Related              5.a substitute

35.          The marketing manager is suggesting switching from a _______ to a __________ strategy

                1.Focus to Differentiation.                 2. Differentiation to Cost   

                3. Related to Unrelated

                                4. Retreat to stability                           5.Star to $ cow

36.          In the Grand strategy model, International Widgets and Things is

                1. a matrix organization    2. Dominant            3. An Analyzer

                4. Unrelated         5. vertically integrated

37.          At the Corporate level, International Widgets and Things is organized

                1. simply                2. Functionally      3.Divisionally

                4. As a Matrix        5. As a.Combinatorally S Corp

a consumer has a utility function u = x^1/2y^1/2. prices are px = 2 and py = 3. she maximizes utility purchasing 6 units of good x. her income is equal to m = ________

Solve the initial value problem. y'=(y^2)+(2xy)+(x^2)-(1), y(0)=1

Given that v⃗ 1=[−3,1] and v⃗ 2=[2,−1] are eigenvectors of the matrix

determine the corresponding eigenvalues. λ1= . λ2= .