Business statistics

profilesty1219179471
App2A_ChartsandGraphs_Excel2013Sp20151.xlsx
Home>Business & Finance homework help>Management homework help>Business statistics

Sheet2

Bins Frequency
230 4
260 13
290 28
320 46
350 49
380 40
410 15
440 5
More 0

Histogram

Frequency

230 260 290 320 350 380 410 440 More 4 13 28 46 49 40 15 5 0

Bins

Frequency

Sheet3

Bins Frequency Cumulative %
230 4 2.00%
260 13 8.50%
290 28 22.50%
320 46 45.50%
350 49 70.00%
380 40 90.00%
410 15 97.50%
440 5 100.00%
More 0 100.00%

Histogram

Frequency 230 260 290 320 350 380 410 440 More 4 13 28 46 49 40 15 5 0 Cumulative % 230 260 290 320 350 380 410 440 More 0.02 8.5000000000000006E-2 0.22500000000000001 0.45500000000000002 0.7 0.9 0.97499999999999998 1 1

Bins

Frequency

Sheet1

Lifetime (Hours) Bins Sony TV Brand Frequency Year Unemployment Rate (%) Country Export ($ Billions, 2006) Export ($ Billion, 2007) Year Nasdaq Stock Index Federal Expenditure 2004 Billions of $ Mid-point Freq.1 Freq.2 Summer Temperature Electricity Used Week Demand Period,T Sales Forecast
314 230 Mitsubishi Sony 21 1980 7.2 Canada 189 212 1984.12 247.1 National Defence 455.9 30 0 1 85 23.6 1 169 1 38
276 260 Sony Mitsubishi 7 1982 10.8 Mexico 111 140 1985.12 324.9 Social Securit 495.5 50 6 5 90 24.8 2 233 2 49
430 290 Sony RCA 5 1984 7.3 Japan 54 60 1986.12 348.8 Medicare 269.3 70 13 13 76 21.4 3 259 3 54
340 320 Panasonic Panasonic 18 1986 6.6 UK 36 32 1987.12 330.5 Medicaid 176.2 90 9 10 91 24.5 4 227 4 49
322 350 Mitsubishi Sharp 9 1988 5.3 China 35 30 1988.12 381.4 Interest on Debt 160.2 110 2 2 84 25.3 5 237 5 51
325 380 Panasonic 1990 6.3 Germany 31 43 1989.12 454.8 Education/Employment 87.9 130 3 1 94 24.6 6 250 6 54
343 410 Sony 1992 7.4 South Korea 26 38 1990.12 373.8 Transportation 64.6 150 3 0 88 24 7 217 7 49
322 440 RCA 1994 5.5 Netherlands 24 20 1991.12 586.34 Retirement and disability 94.8 170 1 0 85 23.5 8 189 8 45
309 RCA 1996 5.4 Taiwan 22 28 1992.12 676.95 Health 63.9 97 27.2 9 180 9 44
271 Sony 1998 4.4 France 21 26 1993.12 776.8 Other 481.5 86 24.2 10 188 10 46 46.84
276 Panasonic 2000 3.9 1994.12 751.96 82 23.6 11 301 11 64 44.52
416 Sony 2002 6 1995.12 1052.13 78 22 12 256 12 58 50.06
306 Sharp 2004 5.4 1996.12 1291.03 77 22.3 13 329 13 70 54.64
387 Sharp 2006 4.4 1997.12 1570.35 83 23.7 14 169 14 45 65.02
375 Panasonic 2008 6.1 1998.12 2192.69 80 23.1 15 285 15 64 63.12
277 Sony 2010 9.5 1999.12 4069.31 95 27.6 16 266 16 61 68.34
359 Sony 2012 7.9 2000.12 2470.52 97 28.4 17 202 17 52 63.84
370 Panasonic 2014 5.9 2001.12 1950.4 100 29.4 18 255 18 61 58.74
215 Mitsubishi 2002.12 1335.51 105 30.6 19 160 19 46 54.18
373 RCA 2003.12 2003.97 102 29 20 206 20 54 54.62
330 Panasonic 2004.12 2175.44 92 25.1 21 258 21 63 51.24
253 Sony 2005.12 2205.32 93 25.4 22 244 22 61 53.56
253 Panasonic 2006.12 2415.29 96 28 23 167 23 49 58.48
298 Sony 2007.12 2652.28 103 31.1 24 214 24 57 53.08
242 Panasonic 2008.12 1577.03 104 31 25 193 25 54 58.58
282 Mitsubishi 2009.12 2269.15 26 283 26 69 57.98
203 Mitsubishi 2010.12 2652.87 27 267 27 67 60.14
325 Sony 2011.12 2605.15 28 195 28 56 62.48
246 Sharp 2012.12 3019.51 29 310 29 75 64.18
302 Sharp 2013.12 4176.59 30 257 30 67 70.96
329 Panasonic 2014.12 4483.72 31 195 31 57 74.46
360 Sony 32 235 32 64 66.54
279 RCA 33 327 33 80 63.66
304 Sony 34 296 34 75 73.26
346 Panasonic 35 262 35 70 71.94
366 Panasonic 36 259 36 70 72.72
363 Sony 37 233 37 67 77.00
357 Panasonic 38 146 38 53 75.92
277 Sony 39 348 39 86 62.90
280 Sony 40 246 40 70 68.22
371 Panasonic 41 236 41 69 68.22
286 Mitsubishi 42 293 42 79 68.56
378 Sharp 43 313 43 82 74.86
330 Sharp 44 402 44 97 86.30
331 Mitsubishi 45 272 45 77 88.74
315 Sony 46 326 46 86 88.76
373 Panasonic 47 242 47 73 92.70
252 Sony 48 242 48 73 86.22
302 Panasonic 49 274 49 79 80.52
331 Panasonic 50 188 50 66 72.06
379 Sharp 51 281 51 81 68.18
337 Sharp 52 180 52 66 68.62
414 Sony 53 183 53 67 68.12
302 Sony 54 254 54 79 67.94
413 RCA 55 289 55 85 69.68
345 Sharp 56 294 56 86 79.12
243 Panasonic 57 211 57 73 80.96
314 Sony 58 335 58 93 82.96
313 Panasonic 59 277 59 85 92.54
339 60 225 60 77 91.76
365 61 251 61 82 85.60
344 62 250 62 82 81.98
306 63 235 63 80 84.74
311 64 273 64 87 78.84
236 65 211 65 77 80.68
328
297
345
260
374
288
273
262
280
309
409
339
348
300
349
267
385
376
318
344
319
276
373
292
355
356
298
372
287
283
312
323
257
322
363
307
349
308
358
418
353
333
317
231
336
302
390
303
368
299
266
297
291
304
297
371
269
339
354
328
336
257
307
338
312
263
215
346
281
335
383
333
358
282
274
297
304
368
406
393
384
367
289
372
354
364
382
331
329
330
289
299
409
410
334
291
319
289
369
267
298
296
363
226
329
337
329
362
309
376
294
302
337
390
359
398
283
344
254
305
398
349
340
365
345
361
306
366
310
260
370
384
347
332
330