2 Watch All The Tutorial Videos Assignment 1 In Excel Generate A Data Table With Two Columns Using The Data Provided 1 (45.31 KiB) Viewed 33 times
2 Watch All The Tutorial Videos Assignment 1 In Excel Generate A Data Table With Two Columns Using The Data Provided 2 (45.72 KiB) Viewed 33 times
2. Watch all the tutorial videos. Assignment 1. In Excel, generate a data table with two columns using the data provided in the table below.¹ X-axis (RUN) Y-axis (RISE) 10.31 0.090 20.62 0.181 40.97 0.368 60.79 0.617 80.62 0.809 100.4 0.977 2. Using the data table, generate an x-y scatter plot. Your plot can be on the same sheet as your data table. 3. Once your scatter plot is generated add a title to the plot. You can simply title the plot, rise versus run. 4. Add axes labels to the x (run) and y (rise) axes. The axis labels give the reader information regarding the variab represented. 5. Add a trendline to the plot. The trendline is generated based on a straight-line plot and will be given in the fo of
1. As noted in step 5 above, the trendline generated by Excel follows a straight line equation, y = mx + b. According to the trendline given in excel, what is the slope (m) of the trendline? Ax' Ay where Ay is the 2. Another way to mathematically calculate the slope of a line is to use the rise/run formula: change in y and Ax is the change in x. Using the FIRST and LAST data rows from Table 1 (rows are horizontal), calculate the slope of the line. Is the slope you calculated using the same as that slope generated by the Excel program? Ay Ax 3. Using the trendline generated by Excel, what would the value of y be if the value of x is 55.25?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!