Administration Assignment (Correlation and Linear Regression)

smashbox
corr_reg_data.xlsx

Question1and2

Year Apparel manufacturing
2001 27.5
2002 25
2003 23.1
2004 23
2006 21.8
2007 22.5
2008 22
2009 20.1
2010 20.1

Question3

Location of breached information Millions of individuals affected
1 78.8
1 11
1 10
0 4.9
1 4.5
1 4.5
0 4
0 3.9
0 2
0 1.9

Question4

Average Check Size Sales
$ 70.00 $ 47,000,000
$ 75.00 $ 38,000,000
$ 85.00 $ 36,136,486
$ 81.00 $ 31,000,000
$ 31.00 $ 30,984,068
$ 37.00 $ 28,056,008
$ 98.00 $ 26,057,894
$ 67.00 $ 24,000,000
$ 115.00 $ 23,500,000
$ 73.00 $ 22,535,918
$ 69.00 $ 21,800,000
$ 84.00 $ 21,425,583
$ 45.00 $ 21,200,000
$ 36.00 $ 21,122,795
$ 75.00 $ 20,900,000
$ 72.00 $ 20,500,000
$ 175.00 $ 19,900,000
$ 110.00 $ 19,300,000
$ 92.00 $ 18,480,000
$ 34.00 $ 18,383,790
$ 89.00 $ 18,100,000
$ 88.00 $ 17,739,203
$ 150.00 $ 17,600,000
$ 135.00 $ 17,600,000
$ 39.00 $ 17,553,828
$ 42.00 $ 17,475,000
$ 65.00 $ 17,200,000
$ 170.00 $ 17,082,107
$ 50.00 $ 16,900,000
$ 55.00 $ 16,895,230
$ 73.00 $ 16,875,000
$ 68.00 $ 16,700,000
$ 67.00 $ 16,700,000
$ 95.00 $ 16,642,234
$ 41.00 $ 16,500,000
$ 50.00 $ 16,500,000
$ 60.00 $ 16,500,000
$ 50.00 $ 16,200,000
$ 93.00 $ 16,200,000
$ 78.00 $ 16,200,000
$ 53.00 $ 16,101,034
$ 65.00 $ 16,000,000
$ 100.00 $ 16,000,000
$ 65.00 $ 15,923,614
$ 101.00 $ 15,810,500
$ 69.00 $ 15,667,052
$ 56.00 $ 15,500,000
$ 52.00 $ 15,458,387
$ 45.00 $ 15,400,000
$ 65.00 $ 15,400,000
$ 88.00 $ 15,337,858
$ 64.00 $ 15,317,781
$ 47.00 $ 15,200,000
$ 75.00 $ 15,175,000
$ 65.00 $ 15,100,000
$ 26.00 $ 15,000,000
$ 27.00 $ 14,900,000
$ 36.00 $ 14,750,000
$ 76.00 $ 14,650,000
$ 27.00 $ 14,599,151
$ 51.00 $ 14,569,655
$ 43.00 $ 14,452,000
$ 70.00 $ 14,400,000
$ 26.00 $ 14,300,000
$ 46.00 $ 14,300,000
$ 72.00 $ 14,276,415
$ 152.00 $ 14,150,000
$ 14.00 $ 14,102,093
$ 110.00 $ 14,100,000
$ 50.00 $ 14,000,000
$ 70.00 $ 13,930,512
$ 43.00 $ 13,900,000
$ 100.00 $ 13,900,000
$ 85.00 $ 13,800,000
$ 56.00 $ 13,800,000
$ 80.00 $ 13,660,000
$ 48.00 $ 13,544,500
$ 26.00 $ 13,526,645
$ 43.00 $ 13,479,570
$ 27.00 $ 13,400,000
$ 28.00 $ 13,199,196
$ 75.00 $ 13,100,000
$ 31.00 $ 13,065,111
$ 16.00 $ 12,993,605
$ 56.00 $ 12,900,000
$ 19.00 $ 12,800,000
$ 78.00 $ 12,700,000
$ 170.00 $ 12,700,000
$ 71.00 $ 12,687,644
$ 85.00 $ 12,650,000
$ 56.00 $ 12,600,000
$ 60.00 $ 12,437,096
$ 50.00 $ 12,300,000
$ 101.00 $ 12,300,000
$ 61.00 $ 12,289,167
$ 100.00 $ 12,118,053
$ 29.00 $ 12,095,816
$ 75.00 $ 12,050,000
$ 45.00 $ 12,039,092
$ 85.00 $ 12,000,000