dolution

dolution.

Having understood the contents of this chapter, you, as the manager of Section B comprising 50 students of MBA 1st year course, are required to form groups of five students each. Include yourself in one of the groups. All the groups have to prepare a 20-minute Power point presentation on the contents of this chapter. Take the help of your professor to form a panel of three students from Section A. All the groups have to make the presentation before this panel in the presence of all the students of Section B. After all the presentations are over the panel has to decide the winner group and the first and second runners-up. Request your professor to lend his supervision to this exercise.

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

dolution.

The file P02_39.xlsx lists the average high school student scores on the SAT exam by state. There are three components of the SAT: critical reading, math, and writing. These components are listed, along with their sum. The percentage of all potential students who took the SAT is also listed by state. Create correlations and scatterplots to explore the following relationships and comment on the results.

a. The relationship between the combined score and the percentage taking the exam.

b. The relationship between the critical reading and writing components.

c. The relationship between a combined verbal component (the average of critical reading and writing) and the math component.

d. The relationship between each of critical reading, math, and writing with the combined score. Are these bound to be highly correlated because the sum of the three components equals the combined score?

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

dolution.

The Wall Street Journal CEO Compensation Study analyzed chief executive officer (CEO) pay from many U.S. companies with fiscal year 2008 revenue of at least $5 billion that filed their proxy statements between October 2008 and March 2009. The data are in the file P02_30.xlsx.

a. Create a new variable Total 2008, the sum of Salary 2008 and Bonus 2008. (Actually, this is not “total” compensation because it omits the very lucrative compensation from stock options.) Also, recode Company Type so that the Technology and Telecommunications are collapsed into a Tech/ Telecomm category.

b. Find the mean, median, and standard deviation of Total 2008, broken down by the recoded Company Type. Also, create side-by-side box plots of Total 2008, again broken down by the recoded Company Type. What do the results tell you about differences in level or variability across company types?

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

dolution

dolution.

The file P02_02.xlsx contains data about 211 movies released in 2006 and 2007.

a. Recode Distributor so that all distributors except for Paramount Pictures, Buena Vista, Fox Searchlight, Universal, Warner Bros., 20th Century Fox, and Sony Pictures are listed as Other. (Those in Other released fewer than 16 movies.) Similarly, recode Genre so that all genres except for Action, Adventure, Thriller/Suspense, Drama, and Comedy are listed as Other. (Again, those in Other are genres with fewer than 16 movies.)

b. Create a crosstabs and an associated column chart for these two recoded variables. Express the counts as percentages so that for any distributor, the percentages add to 100%. Discuss your findings.

dolution

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"