In: Statistics and Probability
Assignment: Enter a linear series of numbers 1, 2, 3, . . . . . 100 in column A from A1 to A100. Enter a second series of numbers 20, 22, 24, . . . . . 218 in Column “B” from B1 to B100. Plot Column “B” as a function of column “A”. Use a linear trend-line and find the equation of the line. Specify the slope and the y-intercept of the line. Save your file and submit it in the submission folder by the due date.
I need it in excel form please!
Also how it was made!