Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. An excel file named sensor.xlsx contains information collected from a set of sensors. The file has been uploaded on BB. Each row contains a

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed

1. An excel file named sensor.xlsx contains information collected from a set of sensors. The file has been uploaded on BB. Each row contains a set of sensor readings, with the first row containing values collected at 0 seconds, the second row containing values collected at 1.0 seconds, and so on. a) Read the data file and store all values collected for sensorl and sensor4 in two separate variables, named sensorl and sensor 4 b) Find both the maximum value and the minimum value recorded on Sensorl and sensor4. Display the values in the command window using fprintf command. The message should be: The maximum value of sensorl is.... and the maximum value of sensor4 is.... c) Find the mean of all sensor and compare them in a table. Use fprintf command to make a table. Please add header for each column. Each column should contain the mean value of each sensors. Time(s) Sensori Sensor2 Sensor Sensor4 Sensor5 0 68.347 72.3469 1 2 67.6751 71.8548 73.6414 80.5608 3 4 5 6 70.6432 73.2823 64.1609 67.697 68.6878 63.9342 63.4028 74.6561 70.0562 66.7743 74.0286 71.1581 65.0512 76.6979 71.4475 63.2135 64.8869 75.1892 68.051 63.0937 7 8 73.1764 66.9929 72.7559 64.5008 70.43 59.9772 67.5346 72.3102 68.395 76.1828 66.8436 58.3739 63.8418 75.2782 69.4339 71.8961 74.721 59.3979 9 10 65.7819 72.4888 77.4425 67.2676 65.7662 68.7683 73.3151 65.729 63.9934 69.4007 69.6735 72.4265 67.0225 69.2517 67.8262 69.6033 77.6758 66.9676 63.2632 70.6432 73.2823 11 12 13 14 15 77.3946 75.6901 16 71.5777 77.7662 73.5395 79.7869 72.5227 79.3226 68.3009 64.3011 68.9444 75.9512 64.419 70.6432 73.2823 64.1609 67.697 17 65.4822 70.1794 66.8623 72.677 2.7644 68.9815 59.7284 70.6628 77.9647 75.0921 62.098 69.6067 66.5917 64.8772 63.8282 71.444 67.8535 70.279 68.1606 72.3469 65.4822 70.1794 66.8623 72.677 2.7644 68.9815 59.7284 70.6628 77.9647 75.0921 62.098 69.6067 66.5917 64.8772 18 19 20 66.5793 63.5403 69.6354 72.3469 65.4822 70.1794 66.8623 72.677 2.7644 21 22 23 24 68.6878 25 63.9342 63.4028 26 68.9815 27 74.6561 28 59.7284 70.6628 77.9647 64.1609 67.697 68.6878 63.9342 63.4028 74.6561 70.0562 66.7743 74.0286 71.1581 65.0512 76.6979 71.4475 66.7766 66.4785 67.6751 71.8548 73.6414 80.5608 63.2135 64.8869 75.1892 68.051 63.0937 71.5777 77.7662 73.5395 79.7869 72.5227 79.3226 68.3009 64.3011 68.9444 75.9512 64.419 29 30 31 32 33 75.0921 62.098 69.6067 66.5917 64.8772 63.8282 71.444 67.8535 70.0562 66.7743 74.0286 71.1581 65.0512 76.6979 71.4475 77.3946 75.6901 66.5793 63.5403 69.6354 73.1764 66.9929 34 35 77.3946 36 37 75.6901 66.5793 63.8282 71.444 67.8535 70.279 68.1606 63.5403 38 39 70.279 68.1606 73.1764 66.9929 63.5403 69.6354 73.1764 66.9929 40 70.6432 41 73.2823 73.2823 4.1609 42 43 67.697 44 72.7559 64.5008 70.43 59.9772 67.5346 72.7559 64.5008 70.43 59.9772 67.5346 4.1609 67.697 68.6878 3.9342 63.4028 72.7559 64.5008 70.43 59.9772 67.5346 68.6878 45 46 63.9342 63.4028 72.3102 74.6561 47 48 70.0562 6.7743 72.3102 68.395 76.1828 74.0286 66.846 49 50 51 52 72.3102 68.395 76.1828 6.8436 58.3739 663.8418 75.2782 8.4339 58.3739 63.8418 53 75.2782 69.4339 54 55 71.8961 56 74.721 57 58 59 60 71.8961 74.721 59.3979 66.7766 66.4785 63.4028 74.6561 70.0562 71.1581 65.0512 76.5979 71.4475 77.3946 75.6901 6.5793 63.5403 69.6354 77.6758 66.9575 63.2632 70.6432 73.2823 64.1609 67.697 61 62 68.395 76.1828 6.8436 58.3739 63.8418 75.2782 69.4339 71.8961 74.721 59.3979 6.7766 66.4785 7.6758 66.966 3.2632 0.6432 73.2823 64.1609 67.97 68.6878 63.9342 3.4028 74.6561 0.0562 66.7743 74.0286 71.1581 65.0512 76.6979 71.4475 59.3979 66.7766 66.4785 63.4028 74.6561 70.0562 66.7743 74.0286 71.1581 65.0512 76.6979 71.4475 77.3946 75.6901 66.5793 63.5403 74.6561 70.0562 66.7743 74.0286 71.1581 65.0512 76.6979 71.4475 7.3946 75.6901 66.5793 63.5403 69.6354 7.6758 6.9676 63.2532 70.6432 73.2823 64.1609 67.697 68.6878 63.9342 63.4028 74.5561 70.0562 66.7743 74.0286 71.1581 65.0512 76.6979 71.4475 63 64 65 6 67 68.6878 63.9342 68 69 70 66.7743 74.0286 71.1581 65.0512 76.6979 71.4475 77.3946 75.6901 66.5793 63.5403 69.6354 73.174 66.9929 72.7559 64.5008 63.4028 74.6561 70.0562 66.7743 74.0286 71 72 9.6354 73 74 71.1581 75 73.1764 66.9929 2.7559 64.5008 76 65.0512 76.6979 71.4475 77 77 78 79 54.5008 0.43 59.9772 67.5346 72.3102 68.395 80 81 82 71.4475 77.3946 75.6901 6.5793 63.5403 9.6354 73.1764 6.9929 72.7559 64.5008 64.5008 70.43 59.9772 7.5346 72.3102 68.395 76.1828 66.8436 58.3739 83 76.1828 84 85 86 71.4475 7.3945 75.6901 66.5793 53.5403 9.6354 73.1764 66.9929 72.7559 4.5008 70.43 599772 7.5346 72.3102 68.395 76.1828 66.8436 58.3739 66.8436 58.3739 63.8418 75.2782 69.4339 71.8961 74.721 71.4475 7.3946 75.6901 6.5793 63.5403 9.6354 73.1764 6.9929 72.7559 64.5008 70.43 59.9772 67.5346 72.3102 68.395 75.1828 6.8436 58.3739 63.8418 75.2782 8 70.43 88 89 0 91 9.3979 59.9772 67.5346 72.3102 68.395 76.1828 66.8436 58.3739 69.4339 71.8961 74.721 59.3979 68.395 76.1828 66.8436 92 93 94 59.3979 68.395 76.1828 95 66.8436 63.8418 96 97 98 63.8418 75.2782 9.4339 71.8961 63.8418 75.2782 9.4339 71.8961 58.3739 63.8418 75.2782 9.4339 63.8418 75.2782 69.4339 71.8961 75.2782 69.4339

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

More Books

Students also viewed these Databases questions