Statistics Data Analysis

CHernandez123
QMB3250DataAnalysis.docx

Section 13.2

13.6

Is an MBA a golden ticket? Pursuing an MBA is a major

personal investment. Tuition and expenses associated with business

school programs are costly, but the high costs come with hopes of

career advancement and high salaries. A prospective MBA student

would like to examine the factors that impact starting salary upon

graduation and decides to develop a model that uses program per-year tuition as a predictor of starting salary. Data were collected for

37 full-time MBA programs offered at private universities. The data

are stored in FTMBA .

A. Construct a scatter plot.

B. Assuming a linear relationship, use the least-squares method to

determine the regression coefficients b0

and b1.

C. Interpret the meaning of the slope, b1, in this problem.

D. Predict the mean starting salary upon graduation for a program

that has a per-year tuition cost of $50,450.

E. What insights do you gain about the relationship between pro-gram per-year tuition and starting salary upon graduation?

13.7

Starbucks Coffee Co. uses a data-based approach to improve

the quality and customer satisfaction of its products. When survey

data indicated that Starbucks needed to improve its package-sealing

process, an experiment was conducted to determine the factors in

the bag-sealing equipment that might be affecting the ease of open-ing the bag without tearing the inner liner of the bag. One factor that could affect the rating of the ability of the bag to resist tears was the plate gap on the bag-sealing equipment. Data were collected on 19 bags in which the plate gap was varied. The results are stored in Starbucks .

A. Construct a scatter plot.

B. Assuming a linear relationship, use the least-squares method to

determine the regression coefficients b0 and b1.

C. Interpret the meaning of the slope, b1, in this problem.

D. Predict the mean tear rating when the plate gap is equal to 0.

E. What should you tell management of Starbucks about the relationship between the plate gap and the tear rating.

13.10

A box office analyst seeks to predict opening weekend box

office gross for movies. Toward this goal, the analyst plans to use

YouTube trailer views as a predictor. For each of 66 movies, the

YouTube trailer view count, the number of YouTube trailer views

from the release of the trailer through the Saturday before a movie

opens, and the opening weekend box office gross (in $millions) are

collected and stored in Movie .

A. Construct a scatter plot.

B. Assuming a linear relationship, use the least-squares method to

determine the regression coefficients b0 and b1.

C. Interpret the meaning of the slope, b1

, in this problem.

D. Predict the mean weekend box office gross for a movie that had

20 million YouTube trailer views.

E. What conclusions can you reach about predicting weekend box

office gross from YouTube trailer views?

MBA Degree Investment

Graduates employed at graduation (%) 10.7 19.6 23.6 11.7 20.1 6.0 22.4 14.1 19.0 22.1 23.1 27.6 30.3 33.1 44.6 29.7 33.3 45.5 26.6 41.0 33.6 38.2 37.1 38.6 40.0 55.3 54.9 63.1 64.3 58.5 55.7 52.0 82.9 33.7 90.2 59.3 94.5 729  730  726  724  728  737  717  720  725  695  710  700  686  683  692  688  692  691  690  683  665  667  682  662  621  642  641  651  632  623  622  558  567  498  482  486  545  63675 67516 66540 67938 66462 66540 66390 68792 64200 63200 66588 61584 61440 57000 55050 55400 55474 51900 53000 50326 46000 47340 49800 45976 37996 47800 46860 49959 38250 33328 43290 41804 49400 33996 23020 41490 39100 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 79.3 85.8 84.9 81.2 82.8 62.8 86.8 77.3 76 83.1 82.1 79.8 76 84 69.099999999999994 78.5 75.2 80.3 75.2 75.7 78.599999999999994 75.3 65.7 60.7 63.6 56.5 68.400000000000006 53.6 60 94.9 18.899999999999999 63.6 26.7 54.2 61.8 35.700000000000003 42.6 Average starting salary and bonus ($) 10.7 19.6 23.6 11.7 20.1 6.0 22.4 14.1 19.0 22.1 23.1 27.6 30.3 33.1 44.6 29.7 33.3 45.5 26.6 41.0 33.6 38.2 37.1 38.6 40.0 55.3 54.9 63.1 64.3 58.5 55.7 52.0 82.9 33.7 90.2 59.3 94.5 729  730  726  724  728  737  717  720  725  695  710  700  686  683  692  688  692  691  690  683  665  667  682  662  621  642  641  651  632  623  622  558  567  498  482  486  545  63675 67516 66540 67938 66462 66540 66390 68792 64200 63200 66588 61584 61440 57000 55050 55400 55474 51900 53000 50326 46000 47340 49800 45976 37996 47800 46860 49959 38250 33328 43290 41804 49400 33996 23020 41490 39100 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 153830 155058 147475 143565 141694 153553 148997 150229 135988 144799 145413 146252 140289 138864 124417 115830 126932 129587 131829 122791 113515 109267 111165 108347 80249 80249 101799 76455 86123 73646 75879 52190 64891 102156 55918 80000 53848

Starbucks

Viscos ity 0 0 0.45 0.85 0.35 0.3 0.7 1.9 0.25 0.1 0.15 3.9 0 0.55000000000000004 0 0.05 0.4 4.3 0 350 350 319 380 350 300 400 350 350 319 380 350 380 350 350 319 319 380 350 Pressure 0 0 0.45 0.85 0.35 0.3 0.7 1.9 0.25 0.1 0.15 3.9 0 0.55000000000000004 0 0.05 0.4 4.3 0 180 170 186 174 180 180 180 190 180 186 186 180 174 180 180 174 174 186 180 Plate Gap 0 0 0.45 0.85 0.35 0.3 0.7 1.9 0.25 0.1 0.15 3.9 0 0.55000000000000004 0 0.05 0.4 4.3 0 0 0 1.8 1.8 0 0 0 0 0 -1.8 -1.8 3 -1.8 0 -3 -1.8 1.8 1.8 0

Movies

Opening Weekend Gross ($mil) The Mummy It Comes At Night Megan Leavey Captain Underpants: The First Epic Movie Wonder Woman Pirates of the Caribbean: Dead Men Tell No Tales Baywatch Everything, Everything Diary of a Wimpy Kid: The Long Haul Alien: Covenant Snatched King Arthur: Legend of the Sword Lowriders Guardians of the Galaxy Vol. 2 How to Be a Latin Lover The Circle Sleight Born in China Free Fire Unforgettable The Promise Phoenix Forgotten The Fate of the Furious The Case for Christ Going in Style Smurfs: The Lost Village The Boss Baby The Zookeeper's Wife Ghost in the Shell CHIPS Life Power Rangers Beauty and the Beast The Belko Experiment Kong: Skull Island The Shack Logan Before I Fall Get Out Rock Dog Collide The Great Wall Fist Fight A Cure for Wellness John Wick: Chapter 2 The LEGO Batman Movie Fifty Shades Darker Rings The Space Between Us A Dog's Purpose Gold Resident Evil: The Final Chapter Split 20th Century Women xXx: Return of Xander Cage The Founder The Resurrection of Gavin Stone Monster Trucks Sleepless Patriots Day The Bye Bye Man Live By Night Silence Hidden Figures Underworld: Blood Wars A Monster Calls 32.246000000000002 6.0010000000000003 3.7679999999999998 23.852 103.251 62.982999999999997 18.504000000000001 11.727 7.1260000000000003 36.161000000000001 19.542000000000002 15.371 2.4039999999999999 146.51 12.252000000000001 9.0340000000000007 1.702 4.79 0.99399999999999999 4.7850000000000001 4.0960000000000001 1.8160000000000001 98.787000000000006 3.968 11.932 13.21 50.198999999999998 3.2890000000000001 18.675999999999998 7.7229999999999999 12.502000000000001 40.299999999999997 174.751 4.1369999999999996 61.024999999999999 16.172000000000001 88.412000000000006 4.6900000000000004 33.377000000000002 3.7050000000000001 1.5129999999999999 18.47 12.202 4.3570000000000002 30.436 53.003 46.606999999999999 13.003 3.775999999 9999998 18.222999999999999 3.4710000000000001 13.602 40.011000000000003 1.385 20.13 3.4039999999999999 1.2070000000000001 10.951000000000001 8.3439999999999994 11.614000000000001 13.500999999999999 5.1059999999999999 1.9850000000000001 22.8 13.689 2.08 YouTube Trailer Views (millions) The Mummy It Comes At Night Megan Leavey Captain Underpants: The First Epic Movie Wonder Woman Pirates of the Caribbean: Dead Men Tell No Tales Baywatch Everything, Everything Diary of a Wimpy Kid: The Long Haul Alien: Covenant Snatched King Arthur: Legend of the Sword Lowriders Guardians of the Galaxy Vol. 2 How to Be a Latin Lover The Circle Sleight Born in China Free Fire Unforgettable The Promise Phoenix Forgotten The Fate of the Furious The Case for Christ Going in Style Smurfs: The Lost Village The Boss Baby The Zookeeper's Wife Ghost in the Shell CHIPS Life Power Rangers Beauty and the Beast The Belko Experiment Kong: Skull Island The Shack Logan Before I Fall Get Out Rock Dog Collide The Great Wall Fist Fight A Cure for Wellness John Wick: Chapter 2 The LEGO Batman Movie Fifty Shades Darker Rings The Space Between Us A Dog's Purpose Gold Resident Evil: The Final Chapter Split 20th Century Women xXx: Return of Xander Cage The Founder The Resurrection of Gavin Stone Monster Trucks Sleepless Patriots Day The Bye Bye Man Live By Night Silence Hidden Figures Underworld: Blood Wars A Monster Calls 57.896999999999998 10.785 10.099 8.7249999999999996 84.204999999999998 34.99 21.763999999999999 5.55 3.8359999999999999 45.615000000000002 7.7910000000000004 28.187000000000001 4.4960000000000004 57.323999999999998 7.3940000000000001 11.145 11.175000000000001 0.50800000000000001 1.0609999999999999 5.3869999999999996 6.3540000000000001 7.7140000000000004 30.87 0.28000000000000003 2.645 8.1240000000000006 52.292000000000002 3.8860000000000001 31.055 7.0810000000000004 13.55 59.295999999999999 80.076999999999998 5.5460000000000003 35.308999999999997 2.532 44.195999999999998 4.9889999999999999 6.63 0.94199999999999995 2.258 11.327 8.9659999999999993 15.177 13.714 31.231000000000002 52.612000000000002 16.234999999999999 6.8840000000000003 11.698 2.827 23.074999999999999 12.606 0.82599999999999996 27.536000000000001 7.2729999999999997 3.323 4.2670000000000003 3.79 7.5970000000000004 12.912000000000001 7.0670000000000002 5.0199999999999996 7.7389999999999999 16.795000000000002 7.6429999999999998