(Solved) : Graphs Data Provided Excel File Data Program9 Excel Spreadsheet File Includes Two Differe Q37201167 . . .
SAMPLE:
DATA:
In this graphs. The data has been provided in the Excel file, “data _program9″. This Excel spreadsheet file includes two different sheets: the first sheet is “Velocities” which includes four columns each column has four velocity values. The second sheet is “Angles” that includes four columns, each column has some angle values Create a script file named Program09. Prompt the User to enter the name of the dataset file. Use the “xlsread” function to read the data and create the desired plots as you see at the next pages of the current file. These plots show the R values calculated by this formula: program assignment we want to read some data from an Excel spreadsheet file and plot some R (0) =-sin(20) for 0 θ (neglecting air resistance versus the angle values. R represents the range of an object shot at an angle θ with respect to the x-axis and an initial velocity Vo. Specifically, you have to take one velocity vector from the first sheet and plot four different graphs using four different angle columns from the second sheet. Assume g is equal to 9.9 m/s Note: You need to download the data file into your current folder before running your code Notes: You may need to use the following commands input figure plot title max xlsread subplot axis length xlabel vtickstext sprintf find eval Sample run: Enter the name of the Excel dataset file: ‘data program9.xlsx Figure1-Velocities are 65, 80, 90, 95 m/s File Edit View Insert Tools Desktop Window Help The initial velocity is 65 m/s and the max is 426.22 The initial velocity is 80 m/s and the max is 645.37 0 02 04 06 08 1 12 1 0 02 04 06 08 1 12 1 Cannon Angle Cannon Angle The initial velocity is 90 m/s and the max is 816.27 The initial velocity is 95 m/s and the max is 911.62 150 0 02 04 06 08 1 Cannon Angle 12 14 0 02 04 0.6 08 1 Cannon Angle 12 14 1 Set 1 Set 2 Set_3Set_4 4 0.050671 0.058178 0.068295 0.045216 5 0.101342 0.116355 0.136591 0.082673 6 0.152013 0.174533 0.204886 0.123588 7 0.202683 0.232711 0.273182 0.165347 8 0.253354 0.290888 0.341477 0.24802 9 0.304025 0.349066 0.371584 0.298456 10 0.354696 0.407243 0.409773 0.330694 11 0.405367 0.465421 0.443323 0.413367 12 0.456038 0.523599 0.478068 0.456875 13 0.506708 0.581776 0.546364 0.496041 14 0.557379 0.639954 0.614659 0.578714 15 0.60805 0.698132 0.656468 0.626414 16 0.658721 0.756309 0.682955 0.661388 17 0.709392 0.814487 0.721459 0.744061 18 0.760063 0.872665 0.75125 0.785491 19 0.810734 0.930842 0.819546 0.826735 20 0.8614040.98902 0.854796 0.909408 21 0.912075 1.047198 0.887841 0.956843 22 0.962746 1.105375 0.956137 0.992082 23 1.013417 1.163553 1.024432 1.074755 24 1.064088 1.22173 1.092728 1.112233 25 1.114759 1.279908 1.121644 1.157429 26 1.16543 1.338086 1.161023 1.20357 27 1.2161 1.368113 1.229319 1.240102 28 1.266771 1.396263 1.297614 1.289755 29 1.317442 1.418784 1.332251 1.322776 30 1.368113 1.454441 1.36591 1.368759 31 1.418784 1.469455 1.434205 1.405449 32 1.469455 1.483296 1.475545 1.488123 33 1.520125 1.512619 1.502501 1.521365 34 1.570796 1.570796 1.570796 1.570796 Show transcribed image text In this graphs. The data has been provided in the Excel file, “data _program9″. This Excel spreadsheet file includes two different sheets: the first sheet is “Velocities” which includes four columns each column has four velocity values. The second sheet is “Angles” that includes four columns, each column has some angle values Create a script file named Program09. Prompt the User to enter the name of the dataset file. Use the “xlsread” function to read the data and create the desired plots as you see at the next pages of the current file. These plots show the R values calculated by this formula: program assignment we want to read some data from an Excel spreadsheet file and plot some R (0) =-sin(20) for 0 θ (neglecting air resistance versus the angle values. R represents the range of an object shot at an angle θ with respect to the x-axis and an initial velocity Vo. Specifically, you have to take one velocity vector from the first sheet and plot four different graphs using four different angle columns from the second sheet. Assume g is equal to 9.9 m/s Note: You need to download the data file into your current folder before running your code Notes: You may need to use the following commands input figure plot title max xlsread subplot axis length xlabel vtickstext sprintf find eval
Sample run: Enter the name of the Excel dataset file: ‘data program9.xlsx Figure1-Velocities are 65, 80, 90, 95 m/s File Edit View Insert Tools Desktop Window Help The initial velocity is 65 m/s and the max is 426.22 The initial velocity is 80 m/s and the max is 645.37 0 02 04 06 08 1 12 1 0 02 04 06 08 1 12 1 Cannon Angle Cannon Angle The initial velocity is 90 m/s and the max is 816.27 The initial velocity is 95 m/s and the max is 911.62 150 0 02 04 06 08 1 Cannon Angle 12 14 0 02 04 0.6 08 1 Cannon Angle 12 14
1 Set 1 Set 2 Set_3Set_4 4 0.050671 0.058178 0.068295 0.045216 5 0.101342 0.116355 0.136591 0.082673 6 0.152013 0.174533 0.204886 0.123588 7 0.202683 0.232711 0.273182 0.165347 8 0.253354 0.290888 0.341477 0.24802 9 0.304025 0.349066 0.371584 0.298456 10 0.354696 0.407243 0.409773 0.330694 11 0.405367 0.465421 0.443323 0.413367 12 0.456038 0.523599 0.478068 0.456875 13 0.506708 0.581776 0.546364 0.496041 14 0.557379 0.639954 0.614659 0.578714 15 0.60805 0.698132 0.656468 0.626414 16 0.658721 0.756309 0.682955 0.661388 17 0.709392 0.814487 0.721459 0.744061 18 0.760063 0.872665 0.75125 0.785491 19 0.810734 0.930842 0.819546 0.826735 20 0.8614040.98902 0.854796 0.909408 21 0.912075 1.047198 0.887841 0.956843 22 0.962746 1.105375 0.956137 0.992082 23 1.013417 1.163553 1.024432 1.074755 24 1.064088 1.22173 1.092728 1.112233 25 1.114759 1.279908 1.121644 1.157429 26 1.16543 1.338086 1.161023 1.20357 27 1.2161 1.368113 1.229319 1.240102 28 1.266771 1.396263 1.297614 1.289755 29 1.317442 1.418784 1.332251 1.322776 30 1.368113 1.454441 1.36591 1.368759 31 1.418784 1.469455 1.434205 1.405449 32 1.469455 1.483296 1.475545 1.488123 33 1.520125 1.512619 1.502501 1.521365 34 1.570796 1.570796 1.570796 1.570796
Expert Answer
Answer to In this graphs. The data has been provided in the Excel file, “data _program9”. This Excel spreadsheet file includes two…
OR