Question: just need to know what to type into excel and where 100% 8:58 AM X Question 2. The amount of farce exerted to compress or

 just need to know what to type into excel and where

just need to know what to type into excel and where

100% 8:58 AM X Question 2. The amount of farce exerted to compress or extend a spring is related to the change in length of that spring. Change in lengthis typically referred to as deflection and is represented with the lower case Greek letter dela, 6. Data was olected on the amount of force (dependent variable) required to deflect a spring a gven amount (ndependent variablej. Force L.O 2.2 2.5 3.2 12.9 26.5 289 39.4 a. Find the equation for the line of best fit using least squares linear regression by calculating the values of slope and y-interpept by hand. Remember you wil not hove Excel on the test so it is good to practice the calculations by hand. You can set up a tabie an your paper just ike you would in Excel, Force-11.86+06 b. Enter the data inta Expel using proper formatting techniques. Use the symbels feature to put the title for deflection in the table as the Greek letter deita 6). c. Use Excel to find the slope and y-merce t. d What are the units for slope?What are the units for y intercapt? e. Plot the data (markers ony) and the fit lires anlyl on the same graph. 100% 8:58 AM X Question 2. The amount of farce exerted to compress or extend a spring is related to the change in length of that spring. Change in lengthis typically referred to as deflection and is represented with the lower case Greek letter dela, 6. Data was olected on the amount of force (dependent variable) required to deflect a spring a gven amount (ndependent variablej. Force L.O 2.2 2.5 3.2 12.9 26.5 289 39.4 a. Find the equation for the line of best fit using least squares linear regression by calculating the values of slope and y-interpept by hand. Remember you wil not hove Excel on the test so it is good to practice the calculations by hand. You can set up a tabie an your paper just ike you would in Excel, Force-11.86+06 b. Enter the data inta Expel using proper formatting techniques. Use the symbels feature to put the title for deflection in the table as the Greek letter deita 6). c. Use Excel to find the slope and y-merce t. d What are the units for slope?What are the units for y intercapt? e. Plot the data (markers ony) and the fit lires anlyl on the same graph

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!