Applied bussiness reseach assignment

profileRama
Mainfile1.xlsx
Home>Business & Finance homework help>Marketing homework help>Applied bussiness reseach assignment

Disposable Income

Date Income
4/1/47 1297.389
7/1/47 1330.650
10/1/47 1311.500
1/1/48 1337.346
4/1/48 1379.140
7/1/48 1401.680
10/1/48 1409.521
1/1/49 1381.840
4/1/49 1388.593
7/1/49 1397.454
10/1/49 1405.357
1/1/50 1513.748
4/1/50 1509.160
7/1/50 1528.085
10/1/50 1537.490
1/1/51 1539.262
4/1/51 1573.537
7/1/51 1591.399
10/1/51 1588.533
1/1/52 1587.714
4/1/52 1607.784
7/1/52 1640.181
10/1/52 1675.391
1/1/53 1695.775
4/1/53 1717.884
7/1/53 1709.703
10/1/53 1703.955
1/1/54 1712.685
4/1/54 1714.307
7/1/54 1732.491
10/1/54 1765.692
1/1/55 1794.461
4/1/55 1833.964
7/1/55 1867.718
10/1/55 1889.488
1/1/56 1908.957
4/1/56 1927.051
7/1/56 1936.904
10/1/56 1966.290
1/1/57 1972.132
4/1/57 1985.982
7/1/57 1996.780
10/1/57 1984.865
1/1/58 1969.849
4/1/58 1982.993
7/1/58 2022.925
10/1/58 2047.586
1/1/59 2065.016
4/1/59 2097.982
7/1/59 2095.120
10/1/59 2110.144
1/1/60 2135.238
4/1/60 2148.635
7/1/60 2152.356
10/1/60 2151.518
1/1/61 2172.363
4/1/61 2205.503
7/1/61 2234.815
10/1/61 2277.906
1/1/62 2299.653
4/1/62 2323.864
7/1/62 2336.029
10/1/62 2356.592
1/1/63 2376.762
4/1/63 2398.911
7/1/63 2425.356
10/1/63 2465.003
1/1/64 2513.370
4/1/64 2580.878
7/1/64 2614.217
10/1/64 2643.856
1/1/65 2674.964
4/1/65 2705.305
7/1/65 2779.451
10/1/65 2835.449
1/1/66 2863.540
4/1/66 2870.907
7/1/66 2905.938
10/1/66 2939.564
1/1/67 2983.437
4/1/67 3006.775
7/1/67 3035.087
10/1/67 3057.059
1/1/68 3109.332
4/1/68 3161.213
7/1/68 3168.870
10/1/68 3190.475
1/1/69 3197.022
4/1/69 3232.163
7/1/69 3300.615
10/1/69 3326.458
1/1/70 3358.951
4/1/70 3398.517
7/1/70 3451.660
10/1/70 3442.941
1/1/71 3511.986
4/1/71 3563.227
7/1/71 3582.192
10/1/71 3623.955
1/1/72 3640.627
4/1/72 3677.764
7/1/72 3748.494
10/1/72 3897.247
1/1/73 3924.912
4/1/73 3956.225
7/1/73 3973.401
10/1/73 4017.065
1/1/74 3950.863
4/1/74 3913.970
7/1/74 3917.747
10/1/74 3912.896
1/1/75 3906.525
4/1/75 4087.848
7/1/75 4028.445
10/1/75 4059.234
1/1/76 4106.855
4/1/76 4128.179
7/1/76 4158.585
10/1/76 4183.351
1/1/77 4182.065
4/1/77 4234.187
7/1/77 4298.960
10/1/77 4382.061
1/1/78 4413.034
4/1/78 4456.647
7/1/78 4488.809
10/1/78 4524.156
1/1/79 4572.250
4/1/79 4532.798
7/1/79 4554.249
10/1/79 4574.296
1/1/80 4589.782
4/1/80 4523.112
7/1/80 4578.310
10/1/80 4668.149
1/1/81 4655.623
4/1/81 4654.522
7/1/81 4749.775
10/1/81 4759.131
1/1/82 4764.829
4/1/82 4792.296
7/1/82 4817.994
10/1/82 4839.681
1/1/83 4881.255
4/1/83 4915.894
7/1/83 4990.052
10/1/83 5097.616
1/1/84 5201.785
4/1/84 5288.251
7/1/84 5360.803
10/1/84 5404.946
1/1/85 5392.014
4/1/85 5495.811
7/1/85 5477.363
10/1/85 5540.314
1/1/86 5609.368
4/1/86 5683.877
7/1/86 5724.107
10/1/86 5734.376
1/1/87 5781.630
4/1/87 5725.536
7/1/87 5829.572
10/1/87 5907.511
1/1/88 5993.682
4/1/88 6055.212
7/1/88 6113.536
10/1/88 6172.581
1/1/89 6248.817
4/1/89 6230.363
7/1/89 6272.845
10/1/89 6323.241
1/1/90 6376.468
3/30/90 6414.640
6/29/90 6417.037
9/28/90 6366.168
12/31/90 6379.730
3/29/91 6423.863
6/28/91 6447.210
9/30/91 6502.332
12/31/91 6641.922
3/31/92 6711.357
6/30/92 6740.671
9/30/92 6763.811
12/31/92 6801.742
3/31/93 6813.697
6/30/93 6817.701
9/30/93 6862.515
12/31/93 6910.602
3/31/94 6983.806
6/30/94 7025.314
9/30/94 7122.963
12/30/94 7190.901
3/31/95 7207.255
6/30/95 7271.651
9/29/95 7313.742
12/29/95 7383.717
3/31/96 7454.301
6/30/96 7513.727
9/30/96 7552.887
12/31/96 7628.691
3/31/97 7693.917
6/30/97 7785.460
9/30/97 7897.061
12/31/97 8065.328
3/31/98 8178.007
6/30/98 8261.362
9/30/98 8328.480
12/31/98 8403.080
3/31/99 8423.895
6/30/99 8480.303
9/30/99 8605.081
12/31/99 8774.569
3/31/00 8865.621
6/30/00 8969.157
9/30/00 8999.501
12/31/00 9076.223
3/31/01 9068.234
6/30/01 9282.636
9/30/01 9167.785
12/31/01 9390.812
3/31/02 9438.448
6/30/02 9426.253
9/30/02 9471.610
12/31/02 9498.000
3/31/03 9635.544
6/30/03 9793.433
9/30/03 9833.026
12/31/03 9904.677
3/31/04 10002.264
6/30/04 10054.941
9/30/04 10180.633
12/31/04 10082.492
3/31/05 10162.278
6/30/05 10214.447
9/30/05 10298.739
12/31/05 10533.962
3/31/06 10549.798
6/30/06 10579.888
9/30/06 10718.365
12/31/06 10788.663
3/31/07 10809.538
6/30/07 10837.871
9/30/07 10846.991
12/31/07 10925.264
3/31/08 11155.661
6/30/08 10899.245
9/30/08 10969.231
12/31/08 10948.502
3/31/09 11026.432
6/30/09 10905.429
9/30/09 10891.014
12/31/09 10902.018
3/31/10 11043.804
6/30/10 11098.757
9/30/10 11176.156
12/31/10 11312.927
3/31/11 11295.233
6/30/11 11355.094
9/30/11 11362.033
12/31/11 11547.786
3/31/12 11636.654
6/30/12 11630.759
9/30/12 11936.122
12/31/12 11437.747
3/31/13 11504.416
6/30/13 11571.732
9/30/13 11596.613
12/31/13 11720.446
3/31/14 11871.513
6/30/14 11995.295
9/30/14 12169.576
12/31/14 12297.642
3/31/15 12414.199
6/30/15 12470.797
9/30/15 12561.187
12/31/15 12567.688
3/31/16 12627.206
6/30/16 12649.232
9/30/16 12590.849
12/31/16 12680.434
3/31/17 12765.604
6/30/17 12780.616

Unemployment rate

Date Unemployment rate
1/1/55 5.6102
4/1/55 4.5786
7/1/55 3.8501
10/1/55 3.7336
1/1/56 4.7926
4/1/56 4.3903
7/1/56 3.8661
10/1/56 3.7088
1/1/57 4.6683
4/1/57 4.2172
7/1/57 3.9147
10/1/57 4.4743
1/1/58 7.5331
4/1/58 7.5596
7/1/58 6.7914
10/1/58 5.7282
1/1/59 6.8765
4/1/59 5.2248
7/1/59 4.9456
10/1/59 5.0990
1/1/60 6.0527
4/1/60 5.3817
7/1/60 5.2426
10/1/60 5.7914
1/1/61 7.9877
4/1/61 7.0622
7/1/61 6.3491
10/1/61 5.6820
1/1/62 6.5361
4/1/62 5.5357
7/1/62 5.2405
10/1/62 5.0725
1/1/63 6.6704
4/1/63 5.8442
7/1/63 5.2908
10/1/63 5.1511
1/1/64 6.2234
4/1/64 5.4064
7/1/64 4.7790
10/1/64 4.5759
1/1/65 5.4864
4/1/65 4.8424
7/1/65 4.2157
10/1/65 3.7753
1/1/66 4.2588
4/1/66 4.0476
7/1/66 3.6478
10/1/66 3.3745
1/1/67 4.1486
4/1/67 3.8142
7/1/67 3.9134
10/1/67 3.6879
1/1/68 4.0474
4/1/68 3.5616
7/1/68 3.6391
10/1/68 3.1859
1/1/69 3.6481
4/1/69 3.4669
7/1/69 3.7255
10/1/69 3.3914
1/1/70 4.5453
4/1/70 4.7461
7/1/70 5.2705
10/1/70 5.4717
1/1/71 6.5556
4/1/71 5.9181
7/1/71 6.0742
10/1/71 5.6181
1/1/72 6.4267
4/1/72 5.6790
7/1/72 5.6568
10/1/72 4.9915
1/1/73 5.5079
4/1/73 4.9250
7/1/73 4.8709
10/1/73 4.4992
1/1/74 5.6475
4/1/74 5.1814
7/1/74 5.6421
10/1/74 6.2372
1/1/75 9.2053
4/1/75 8.7612
7/1/75 8.4269
10/1/75 7.8525
1/1/76 8.5902
4/1/76 7.4526
7/1/76 7.6890
10/1/76 7.4144
1/1/77 8.2954
4/1/77 7.0122
7/1/77 6.8989
10/1/77 6.3235
1/1/78 6.9305
4/1/78 5.9017
7/1/78 6.0553
10/1/78 5.6492
1/1/79 6.3888
4/1/79 5.6752
7/1/79 5.8988
10/1/79 5.7325
1/1/80 6.8657
4/1/80 7.3024
7/1/80 7.6575
10/1/80 7.1973
1/1/81 8.0997
4/1/81 7.4002
7/1/81 7.4083
10/1/81 8.0569
1/1/82 9.6651
4/1/82 9.4940
7/1/82 9.8593
7/1/83 9.2547
10/1/83 8.3262
1/1/84 8.5783
4/1/84 7.5144
7/1/84 7.3941
10/1/84 7.0629
1/1/85 7.9185
4/1/85 7.3097
7/1/85 7.1599
10/1/85 6.8284
1/1/86 7.6364
4/1/86 7.2063
7/1/86 6.9305
10/1/86 6.6143
1/1/87 7.2422
4/1/87 6.3149
7/1/87 5.9727
10/1/87 5.6589
1/1/88 6.2554
4/1/88 5.4976
7/1/88 5.4533
10/1/88 5.1503
1/1/89 5.6994
4/1/89 5.2569
7/1/89 5.2474
10/1/89 5.1586
1/1/90 5.8359
3/30/90 5.3748
6/29/90 5.6238
9/28/90 5.8561
12/31/90 7.2741
3/29/91 6.8596
6/28/91 6.7638
9/30/91 6.8120
12/31/91 8.1559
3/31/92 7.5923
6/30/92 7.5626
9/30/92 7.1189
12/31/92 7.8597
3/31/93 7.1057
6/30/93 6.7833
9/30/93 6.3533
12/31/93 7.1937
3/31/94 6.1843
6/30/94 5.9829
9/30/94 5.3144
12/30/94 5.9711
3/31/95 5.6730
6/30/95 5.6573
9/29/95 5.2743
12/29/95 6.0813
3/31/96 5.4556
6/30/96 5.2835
9/30/96 5.0093
12/31/96 5.7436
3/31/97 4.9628
6/30/97 4.8767
9/30/97 4.4020
12/31/97 5.1124
3/31/98 4.3959
6/30/98 4.5483
9/30/98 4.1438
12/31/98 4.6936
3/31/99 4.2130
6/30/99 4.2614
9/30/99 3.8442
12/31/99 4.4148
3/31/00 3.9150
6/30/00 4.0464
9/30/00 3.7078
12/31/00 4.6359
3/31/01 4.4138
6/30/01 4.8223
9/30/01 5.2748
12/31/01 6.2552
3/31/02 5.8184
6/30/02 5.7242
9/30/02 5.6091
12/31/02 6.3984
3/31/03 6.1374
6/30/03 6.0991
9/30/03 5.6115
12/31/03 6.1748
3/31/04 5.5654
6/30/04 5.4557
9/30/04 5.1959
12/31/04 5.7010
3/31/05 5.0896
6/30/05 5.0198
9/30/05 4.7655
12/31/05 5.0996
3/31/06 4.6636
6/30/06 4.7093
9/30/06 4.2833
12/31/06 4.8737
3/31/07 4.4826
6/30/07 4.7243
9/30/07 4.6197
12/31/07 5.3255
3/31/08 5.3195
6/30/08 6.0904
9/30/08 6.6547
12/31/08 8.9206
3/31/09 9.2413
6/30/09 9.7086
9/30/09 9.6411
3/31/10 9.6464
6/30/10 9.6077
9/30/10 9.2790
12/31/10 9.6462
3/31/11 9.0402
6/30/11 9.1663
9/30/11 8.4128
12/31/11 8.7615
3/31/12 8.1084
6/30/12 8.1851
9/30/12 7.6074
12/31/12 8.1818
3/31/13 7.5094
6/30/13 7.4739
9/30/13 6.7758
12/31/13 7.0823
3/31/14 6.1510
6/30/14 6.2478
9/30/14 5.5402
12/31/14 5.9152
3/31/15 5.4000
6/30/15 5.3000
9/30/15 4.9000
12/31/15 5.3000
3/31/16 4.8000
6/30/16 5.0000
9/30/16 4.6000
12/31/16 4.9000

population

Date Work population
1/1/55 95552
4/1/55 95863
7/1/55 96105
10/1/55 96297
1/1/56 96505
4/1/56 96719
7/1/56 97039
10/1/56 97247
1/1/57 97455
4/1/57 97697
7/1/57 98033
10/1/57 98373
1/1/58 98688
4/1/58 98926
7/1/58 99160
10/1/58 99492
1/1/59 99848
4/1/59 100202
7/1/59 100527
10/1/59 100801
1/1/60 101481
4/1/60 101758
7/1/60 102044
10/1/60 102350
1/1/61 102706
4/1/61 103002
7/1/61 103271
10/1/61 103358
1/1/62 103473
4/1/62 103125
7/1/62 103603
10/1/62 104194
1/1/63 104732
4/1/63 105224
7/1/63 105728
10/1/63 106198
1/1/64 106662
4/1/64 107099
7/1/64 107556
10/1/64 108019
1/1/65 108482
4/1/65 108940
7/1/65 109282
10/1/65 109616
1/1/66 109895
4/1/66 110193
7/1/66 110492
10/1/66 110785
1/1/67 111136
4/1/67 111548
7/1/67 112099
10/1/67 112591
1/1/68 113038
4/1/68 113432
7/1/68 113870
10/1/68 114413
1/1/69 114950
4/1/69 115410
7/1/69 115896
10/1/69 116449
1/1/70 117082
4/1/70 117730
7/1/70 118403
10/1/70 119095
1/1/71 119778
4/1/71 120475
7/1/71 121153
10/1/71 121833
1/1/72 123120
4/1/72 123811
7/1/72 124454
10/1/72 125023
1/1/73 125697
4/1/73 126405
7/1/73 127045
10/1/73 127685
1/1/74 128247
4/1/74 128877
7/1/74 129493
10/1/74 130086
1/1/75 130681
4/1/75 131269
7/1/75 131974
10/1/75 132584
1/1/76 133189
4/1/76 133769
7/1/76 134378
10/1/76 134929
1/1/77 135533
4/1/77 136140
7/1/77 136758
10/1/77 137314
1/1/78 137878
4/1/78 138447
7/1/78 139031
10/1/78 139622
1/1/79 140224
4/1/79 140769
7/1/79 141360
10/1/79 142037
1/1/80 142614
4/1/80 143142
7/1/80 143690
10/1/80 144135
1/1/81 144625
4/1/81 145070
7/1/81 145499
10/1/81 145925
1/1/82 146311
4/1/82 146699
7/1/82 147069
10/1/82 147456
1/1/83 147806
4/1/83 148146
7/1/83 148497
10/1/83 148843
1/1/84 149449
4/1/84 149775
7/1/84 150102
10/1/84 150474
1/1/85 150731
4/1/85 151037
7/1/85 151344
10/1/85 151721
1/1/86 152569
4/1/86 152888
7/1/86 153258
10/1/86 153646
1/1/87 154107
4/1/87 154486
7/1/87 154825
10/1/87 155160
1/1/88 155502
4/1/88 155839
7/1/88 156206
10/1/88 156456
1/1/89 156817
4/1/89 157060
7/1/89 157381
10/1/89 157628
1/1/90 159447
3/30/90 159722
6/29/90 160045
9/28/90 160454
12/31/90 160720
3/29/91 161026
6/28/91 161364
9/30/91 161789
12/31/91 162075
3/31/92 162369
6/30/92 162801
9/30/92 163262
12/31/92 163609
3/31/93 163956
6/30/93 164385
9/30/93 164864
12/31/93 165234
3/31/94 165582
6/30/94 165951
9/30/94 166439
12/30/94 166583
3/31/95 166904
6/30/95 167306
9/29/95 167753
12/29/95 168093
3/31/96 168607
6/30/96 169081
9/30/96 169576
12/31/96 170458
3/31/97 170924
6/30/97 171343
9/30/97 171851
12/31/97 172234
3/31/98 172728
6/30/98 173183
9/30/98 173785
12/31/98 174508
3/31/99 174988
6/30/99 175480
9/30/99 176101
12/31/99 178274
3/31/00 178789
6/30/00 179400
9/30/00 179978
12/31/00 180499
3/31/01 181074
6/30/01 181771
9/30/01 182338
12/31/01 182898
3/31/02 183448
6/30/02 184092
9/30/02 184609
12/31/02 185983
3/31/03 186586
6/30/03 187224
9/30/03 187864
12/31/03 187892
3/31/04 188434
6/30/04 189024
9/30/04 189642
12/31/04 190113
3/31/05 190664
6/30/05 191289
9/30/05 191991
12/31/05 192358
3/31/06 192876
6/30/06 193490
9/30/06 194082
12/31/06 194868
3/31/07 195353
6/30/07 195918
9/30/07 196417
12/31/07 195940
3/31/08 196355
6/30/08 196867
9/30/08 197345
12/31/08 197190
3/31/09 197548
6/30/09 198033
9/30/09 198442
12/31/09 198548
3/31/10 198896
6/30/10 199312
9/30/10 199737
12/31/10 199440
3/31/11 199802
6/30/11 200088
9/30/11 200226
12/31/11 201204
3/31/12 201357
6/30/12 201485
9/30/12 201614
12/31/12 201975
3/31/13 202173
6/30/13 202371
9/30/13 202551
12/31/13 202677
3/31/14 202858
6/30/14 203110
9/30/14 203304
12/31/14 203965
3/31/15 203965
6/30/15 204139
9/30/15 204443
12/31/15 204620
3/31/16 205157
6/30/16 205368
9/30/16 205636
12/31/16 205851
3/31/17 205330
6/30/17 205421