Data Question
Description
The Excel file below contains approximately 25 seconds of acceleration data during walking measured by a smartphone. Process this acceleration data to count your steps. Work with this Excel file and submit the completed Excel file.
Unformatted Attachment Preview
2
1
0
-1
-2
-3
-4
-5
35:39.4
acceleration X
acceleration Y
acceleration Z
35:39.0
-0.184158
-0.313965
-1.305496
35:39.1
-0.54924
-0.437073
-3.067474
35:39.2
0.217972
0.056519
-0.737396
35:39.3
0.135666
0.62027
0.083176
35:39.4
0.394485
0.441345
0.463577
35:39.5
1.767441
0.136688
-1.179779
35:39.6
0.922043
-0.557816
-2.572296
35:39.7
-0.132294
-0.549515
-1.427948
35:39.8
-0.304398
-0.359497
-0.77272
35:39.9
0.159622
0.312759
-1.301941
35:40.0
0.330902
0.829727
-1.123627
35:40.1
0.224106
0.505783
-0.07724
35:40.2
0.58728
0.000992
-0.267563
35:40.3
0.739166
-0.505768
-1.389053
35:40.4
0.103928
-0.45401
-1.234955
35:40.5
-0.352386
-0.219879
-0.762833
35:40.6
-0.30719
-0.331802
0.072067
35:40.7
-0.629501
-0.58783
-1.40123
35:40.8
0.465546
0.606049
-2.267624
35:40.9
0.423935
0.245087
-0.294174
35:41.0
0.24556
0.121719
0.243271
35:41.1
0.714951
-0.310318
-1.713135
35:41.2
0.162872
0.104767
-1.995483
35:41.3
-0.375305
-0.024841
-1.163254
35:41.4
-0.407104
-0.252731
0.112045
35:41.5
-0.644196
-0.409637
-1.264984
35:41.6
0.242035
0.341644
-2.097107
35:41.7
0.487152
0.322495
-0.513947
35:41.8
0.340363
0.135086
-0.072906
35:41.9
0.563324
0.082932
-1.448486
35:42.0
0.222794
-0.231262
-2.196182
35:42.1
-0.386459
-0.069443
-1.255905
35:42.2
-0.442642
-0.181519
-0.097214
35:42.3
-0.517303
-0.089539
-1.449234
35:42.4
0.088348
0.491135
-2.582657
35:42.5
0.396713
0.0728
-0.333588
35:42.6
0.216858
-0.102753
-0.105225
35:42.6
0.362625
-0.209976
-1.539612
35:42.8
0.602402
0.481247
-2.63588
35:42.8
-0.480621
-0.27594
-0.50444
35:42.9
-0.258011
-0.415298
-0.262131
35:43.0
-0.259079
-0.218399
-1.17746
35:39.0
time
35:43.1
35:43.2
35:43.3
35:43.4
35:43.5
35:43.6
35:43.7
35:43.8
35:43.9
35:44.0
35:44.1
35:44.2
35:44.3
35:44.4
35:44.5
35:44.6
35:44.7
35:44.8
35:44.9
35:45.0
35:45.1
35:45.2
35:45.3
35:45.4
35:45.5
35:45.6
35:45.7
35:45.8
35:45.9
35:46.0
35:46.1
35:46.2
35:46.3
35:46.4
35:46.5
35:46.6
35:46.7
35:46.8
35:46.9
35:47.0
35:47.1
35:47.2
35:47.2
0.149673
0.152786
0.423309
0.720993
0.292099
-0.557266
-0.614548
-0.527664
0.491928
0.482086
0.339951
0.582993
0.311066
-0.513199
-0.67363
-0.820114
0.364792
0.646332
0.566254
0.007889
-0.21759
-0.800903
-0.949036
-0.450195
0.444855
0.693207
0.41214
-0.253143
-0.157471
-0.579987
-0.517807
-0.364716
0.146713
0.449829
0.411087
-0.105988
-0.372864
-0.321854
-0.371552
0.005676
0.222092
0.374344
0.441589
0.336594
0.117599
-0.083664
-0.351562
0.086121
-0.061813
-0.371887
-0.404633
0.278839
0.18158
0.062317
-0.262817
0.092377
-0.077438
-0.204391
0.068253
0.571152
-0.04924
0.195511
-0.500244
-0.494446
-0.097412
-0.120514
0.006927
0.082047
0.019531
0.031525
-0.055908
-0.223068
-0.140839
-0.269257
-0.159012
0.063812
0.135559
-0.036926
0.24678
-0.28949
-0.409302
-0.064651
0.45433
0.337173
0.076614
0.049667
-2.805817
-0.34848
-0.155441
-1.538269
-1.940125
-0.69426
-0.248383
-1.194016
-2.631149
-0.196854
0.292709
-1.766098
-2.103989
-0.898376
-0.200867
-1.957245
-1.876633
-0.311508
-0.193359
-1.027466
-1.51416
-0.71785
-0.721924
-1.754547
-0.860031
-0.129654
-0.50383
-1.634293
-1.573868
-0.328308
-0.5495
-2.294189
-0.630386
0.020264
-0.764511
-2.60112
-0.980286
-0.418076
-1.163773
-2.657852
-0.321259
-0.179962
-0.719742
35:47.3
35:47.4
35:47.5
35:47.6
35:47.7
35:47.8
35:47.9
35:48.0
35:48.1
35:48.2
35:48.3
35:48.4
35:48.5
35:48.6
35:48.7
35:48.8
35:48.9
35:49.0
35:49.1
35:49.2
35:49.3
35:49.4
35:49.5
35:49.6
35:49.7
35:49.8
35:49.9
35:50.0
35:50.1
35:50.2
35:50.3
35:50.4
35:50.5
35:50.6
35:50.7
35:50.8
35:50.9
35:51.0
35:51.1
35:51.2
35:51.3
35:51.4
35:51.5
0.242233
-0.269928
-0.371902
-0.711105
-0.534027
0.024109
0.350937
0.374237
0.076645
-0.102798
-0.413528
-0.420868
-0.832153
0.323318
0.447433
0.386978
-0.22905
-0.279404
-0.31134
-0.411484
-0.960403
0.090576
0.294418
0.290665
0.291306
-0.07579
-0.290024
-0.430145
-0.615601
0.140121
0.227921
0.203445
0.553787
0.320419
-0.178268
-0.294876
-0.512192
-0.272156
0.430771
0.506119
0.575653
0.41597
-0.535172
0.166443
-0.369003
-0.257904
-0.003799
-0.030838
-0.097641
0.113556
0.068939
0.1577
-0.209015
-0.241806
-0.383621
-0.126099
0.216019
0.064423
0.128952
-0.50499
-0.252365
-0.143402
-0.0681
-0.530243
0.199905
0.076202
0.013702
-0.812729
0.038345
-0.228485
-0.153214
-0.431641
0.095978
-0.104446
0.022964
-0.427612
-0.096893
-0.45018
-0.112274
-0.304626
0.024185
-0.065811
-0.140518
0.018829
0.329773
-0.458801
-1.963425
-1.092728
-0.341019
-0.496796
-1.953323
-0.774857
-0.398758
-0.415253
-2.27829
-1.114044
-0.523422
-0.465881
-1.521301
-1.376495
0.043137
-0.040451
-1.324463
-1.741699
-0.483063
-0.189713
-1.801941
-1.519547
-0.118851
0.072388
-1.383713
-1.667007
-0.630676
-0.123993
-1.401855
-2.07132
-0.477463
0.006378
-0.918213
-2.394547
-0.999527
-0.381042
-0.999985
-1.962952
-0.618912
-0.064255
-1.000732
-3.190094
-0.673782
35:51.6
35:51.7
35:51.8
35:51.8
35:51.9
35:52.0
35:52.1
35:52.2
35:52.3
35:52.4
35:52.5
35:52.6
35:52.7
35:52.8
35:52.9
35:53.0
35:53.1
35:53.2
35:53.3
35:53.4
35:53.5
35:53.6
35:53.7
35:53.8
35:53.9
35:54.0
35:54.1
35:54.2
35:54.3
35:54.4
35:54.5
35:54.6
35:54.7
35:54.8
35:54.9
35:55.0
35:55.1
35:55.2
35:55.3
35:55.4
35:55.5
35:55.6
35:55.7
-0.514938
-0.276779
0.090912
0.378326
0.440079
0.375748
0.513916
-0.272141
-0.386383
-0.522461
0.058426
-0.057785
0.241028
0.33667
0.741211
-0.161499
-0.124939
-0.521011
-0.394653
0.606644
0.61554
0.235306
0.252472
0.030518
-0.157623
-0.447647
-0.390823
0.237289
0.372894
0.404175
0.512009
-0.085571
-0.111237
-0.332245
-0.420074
0.52623
0.552475
0.425705
0.730118
0.643524
-0.310623
-0.211151
-0.337143
-0.147873
0.038925
0.634964
0.125626
0.115723
-0.049149
0.262375
-0.550415
-0.177551
-0.168701
0.255188
-0.076843
0.132828
-0.226425
-0.470734
-0.452408
-0.375824
-0.12352
-0.132217
0.084564
-0.145142
0.044159
0.653503
-0.377533
-0.231949
-0.127289
0.328537
0.155609
0.23082
-0.079773
0.11026
-0.481369
-0.163101
-0.217712
-0.677124
0.252686
0.422882
0.453064
-0.181717
-0.744308
-0.04451
-0.247116
-0.222122
-0.259613
-0.985779
-4.101318
-0.393494
0.10704
-0.474976
-2.931732
-0.802689
-0.176346
-0.305328
-3.731506
-0.54451
-0.352127
-0.19281
-2.356262
-0.860855
-0.391083
-0.314255
-2.665146
-1.187576
-0.148254
-0.984222
-3.048218
-0.997635
-0.259964
-0.674438
-3.152267
-0.862061
-0.171646
-0.256744
-3.09111
-0.972046
-0.801208
-0.194031
-2.689377
-1.407791
0.063705
0.211578
-1.144333
-2.063324
-1.061371
-0.285614
-1.059753
35:55.8
35:55.9
35:56.0
35:56.1
35:56.2
35:56.2
35:56.3
35:56.4
35:56.5
35:56.6
35:56.7
35:56.8
35:56.9
35:57.0
35:57.1
35:57.2
35:57.3
35:57.4
35:57.5
35:57.6
35:57.7
35:57.8
35:57.9
35:58.0
35:58.1
35:58.2
35:58.3
35:58.4
35:58.5
35:58.6
35:58.7
35:58.8
35:58.9
35:59.0
35:59.1
35:59.2
35:59.3
35:59.4
35:59.5
35:59.6
35:59.7
35:59.8
35:59.9
0.399643
0.380661
0.262177
0.477386
0.856461
-0.252411
-0.318665
-0.291733
-0.187515
0.372345
0.331558
0.479614
0.780151
-0.51297
-0.349579
-0.333496
-0.333893
0.387268
0.434967
0.435974
0.831116
-0.415695
-0.407211
-0.343063
0.004761
0.339951
0.351074
0.435501
0.717392
-0.506927
-0.250656
-0.308289
-0.773499
0.072067
0.2453
0.233032
0.129486
0.729889
-0.034424
-0.293839
-0.319351
0.027786
0.846725
0.162033
0.196884
0.010193
-0.393921
0.031876
0.011795
-0.097733
-0.125076
0.262848
-0.058563
-0.16597
-0.005066
0.271515
-0.216721
-0.196701
-0.026596
0.163361
-0.063141
-0.209183
-0.05925
0.696594
-0.031174
-0.274597
-0.027664
0.599503
-0.197647
-0.156769
0.165344
0.242462
-0.684479
0.004257
-0.055069
-0.695679
-0.25856
-0.147064
-0.111053
-0.245895
0.403259
-0.505463
-0.09906
-0.065369
-0.283447
0.034134
-2.828186
-0.38826
0.236694
-0.946304
-2.384796
-1.109314
-0.183517
-1.09729
-2.48999
-0.693253
-0.016098
-1.004883
-2.867081
-0.669174
-0.359573
-1.080627
-2.199646
-0.466156
0.08815
-1.271164
-3.865723
-0.490601
-0.29689
-1.026627
-3.437729
-0.38266
-0.059387
-1.032867
-2.761749
0.229462
-0.769577
-0.193695
-1.021317
-1.327499
-0.535355
-0.184341
-0.630661
-3.440842
-0.694794
-0.226913
-0.150925
-1.939056
-1.934875
36:00.0
36:00.1
36:00.2
36:00.3
36:00.4
36:00.5
36:00.6
36:00.6
36:00.7
36:00.8
36:00.9
36:01.0
36:01.1
36:01.2
36:01.3
36:01.4
36:01.5
36:01.6
36:01.7
36:01.8
36:01.9
36:02.0
36:02.1
36:02.2
36:02.3
36:02.4
36:02.5
36:02.6
36:02.7
36:02.8
36:02.9
36:03.0
36:03.1
36:03.2
36:03.3
36:03.4
36:03.5
36:03.6
36:03.7
0.334335
0.212616
0.208786
0.639984
0.28273
-0.061569
-0.103195
0.126282
0.429611
0.066101
0.083771
0.157074
-0.035019
-0.091461
-0.00531
0.0522
0.061279
0.031143
0.00386
-0.009857
0.003372
-0.015015
-0.015335
0.000778
0.017044
0.013855
-0.013626
-0.007355
-0.043304
-0.02739
-0.006332
0.041794
0.069351
0.13324
0.130203
0.136734
0.179611
0.163147
0.180054
0.148941
-0.023285
-0.218719
-0.320145
-0.376984
-0.155411
-0.120605
-0.360565
0.048203
-0.022507
-0.133347
-0.143372
-0.185593
-0.18428
-0.004471
-0.030807
-0.127213
-0.091705
-0.127426
-0.130951
-0.120529
-0.10585
-0.065475
-0.10231
-0.113113
-0.124908
-0.105118
-0.117813
-0.120865
-0.126175
-0.153381
-0.168167
-0.15358
-0.152664
-0.159073
-0.181763
-0.235748
-0.193024
-0.204895
-0.26683
0.18927
-0.161926
-1.97435
-1.321304
-0.56427
-0.531555
-1.030914
-1.545731
-0.480209
-0.556137
-1.393936
-0.897324
-0.93013
-1.279404
-0.954483
-0.893021
-1.02916
-0.956726
-0.995316
-1.02623
-0.962234
-1.027817
-0.996902
-1.001724
-1.018188
-1.035858
-1.075638
-1.032776
-0.976151
-0.884827
-0.986053
-0.992249
-0.97908
-0.932358
-0.96022
-0.999512
-0.97287
-0.941193
acceleration X
acceleration Y
35:53.1
35:52.7
35:52.3
35:51.9
35:51.6
35:51.2
35:50.8
35:50.4
35:50.0
35:49.6
35:49.2
35:48.8
35:48.4
35:48.0
35:47.6
35:47.2
35:46.9
35:46.5
35:46.1
35:45.7
35:45.3
35:44.9
35:44.5
35:44.1
35:43.7
35:43.3
35:42.9
35:42.6
35:42.2
35:41.8
35:41.4
35:41.0
35:40.6
35:40.2
35:39.8
35:39.4
35:39.0
Raw Acceleration Data
acceleration Z
36:03.7
36:03.3
36:02.9
36:02.5
36:02.1
36:01.7
36:01.3
36:00.9
36:00.6
36:00.2
35:59.8
35:59.4
35:59.0
35:58.6
35:58.2
35:57.8
35:57.4
35:57.0
35:56.6
35:56.2
35:55.9
35:55.5
35:55.1
35:54.7
35:54.3
35:53.9
35:53.5
35:53.1
35:52.7
ation Data
Purchase answer to see full
attachment
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."