Question: using this excel sheet, Mass = 1 kg Mass = 5 kg Mass = 10 kg Mass = 15 kg Mass 20 kg Height (m)
using this excel sheet,
| Mass = 1 kg | Mass = 5 kg | Mass = 10 kg | Mass = 15 kg | Mass 20 kg | |||||||||||||||
| Height (m) | Energy (J) | Height (m) | Energy (J) | Height (m) | Energy (J) | Height (m) | Energy (J) | Height (m) | Energy (J) | ||||||||||
| 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||
| 5 | 49.05 | 5 | 245.25 | 5 | 490.5 | 5 | 735.75 | 5 | 981 | ||||||||||
| 10 | 98.1 | 10 | 490.5 | 10 | 981 | 10 | 1471.5 | 10 | 1962 | ||||||||||
| 15 | 147.15 | 15 | 735.75 | 15 | 1471.5 | 15 | 2207.25 | 15 | 2943 | ||||||||||
| 20 | 196.2 | 20 | 981 | 20 | 1962 | 20 | 2943 | 20 | 3924 | ||||||||||
| 25 | 245.25 | 25 | 1226.25 | 25 | 2452.5 | 25 | 3678.75 | 25 | 4905 | ||||||||||
| 30 | 294.3 | 30 | 1471.5 | 30 | 2943 | 30 | 4414.5 | 30 | 5886 | ||||||||||
| 35 | 343.35 | 35 | 1716.75 | 35 | 3433.5 | 35 | 5150.25 | 35 | 6867 | ||||||||||
| 40 | 392.4 | 40 | 1962 | 40 | 3924 | 40 | 5886 | 40 | 7848 | ||||||||||
| 45 | 441.45 | 45 | 2207.25 | 45 | 4414.5 | 45 | 6621.75 | 45 | 8829 | ||||||||||
| 50 | 490.5 | 50 | 2452.5 | 50 | 4905 | 50 | 7357.5 | 50 | 9810 | ||||||||||
| 55 | 539.55 | 55 | 2697.75 | 55 | 5395.5 | 55 | 8093.25 | 55 | 10791 | ||||||||||
| 60 | 588.6 | 60 | 2943 | 60 | 5886 | 60 | 8829 | 60 | 11772 | ||||||||||
| 65 | 637.65 | 65 | 3188.25 | 65 | 6376.5 | 65 | 9564.75 | 65 | 12753 | ||||||||||
| 70 | 686.7 | 70 | 3433.5 | 70 | 6867 | 70 | 10300.5 | 70 | 13734 | ||||||||||
| 75 | 735.75 | 75 | 3678.75 | 75 | 7357.5 | 75 | 11036.25 | 75 | 14715 | ||||||||||
| 80 | 784.8 | 80 | 3924 | 80 | 7848 | 80 | 11772 | 80 | 15696 | ||||||||||
| 85 | 833.85 | 85 | 4169.25 | 85 | 8338.5 | 85 | 12507.75 | 85 | 16677 | ||||||||||
| 90 | 882.9 | 90 | 4414.5 | 90 | 8829 | 90 | 13243.5 | 90 | 17658 | ||||||||||
| 95 | 931.95 | 95 | 4659.75 | 95 | 9319.5 | 95 | 13979.25 | 95 | 18639 | ||||||||||
| 100 | 981 | 100 | 4905 | 100 | 9810 | 100 | 14715 | 100 | 19620 | ||||||||||
| 105 | 1030.05 | 105 | 5150.25 | 105 | 10300.5 | 105 | 15450.75 | 105 | 20601 | ||||||||||
| 110 | 1079.1 | 110 | 5395.5 | 110 | 10791 | 110 | 16186.5 | 110 | 21582 | ||||||||||
| 115 | 1128.15 | 115 | 5640.75 | 115 | 11281.5 | 115 | 16922.25 | 115 | 22563 | ||||||||||
| 120 | 1177.2 | 120 | 5886 | 120 | 11772 | 120 | 17658 | 120 | 23544 | ||||||||||
| 125 | 1226.25 | 125 | 6131.25 | 125 | 12262.5 | 125 | 18393.75 | 125 | 24525 | ||||||||||
| 130 | 1275.3 | 130 | 6376.5 | 130 | 12753 | 130 | 19129.5 | 130 | 25506 | ||||||||||
| 135 | 1324.35 | 135 | 6621.75 | 135 | 13243.5 | 135 | 19865.25 | 135 | 26487 | ||||||||||
| 140 | 1373.4 | 140 | 6867 | 140 | 13734 | 140 | 20601 | 140 | 27468 | ||||||||||
| 145 | 1422.45 | 145 | 7112.25 | 145 | 14224.5 | 145 | 21336.75 | 145 | 28449 | ||||||||||
| 150 | 1471.5 | 150 | 7357.5 | 150 | 14715 | 150 | 22072.5 | 150 | 29430 | ||||||||||
| 155 | 1520.55 | 155 | 7602.75 | 155 | 15205.5 | 155 | 22808.25 | 155 | 30411 | ||||||||||
| i have to do this homework for MATLAB and need help 1. Write a program that imports the data from the first excel sheet and plot each data set on the same plot. Create another program that plots all the data on its own graph but in the same window. Remember to include titles, legends, and axes labels. 2. Write a program that will read the data from the second tab. Use polyfit to create a linear best fit line. Calculate the R2 value for fit. Plot both the individual data points (red) and the fit line (blue) on the same graph. Include a title and axis labels.
| |||||||||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
