Question: Please help, The first part is how to do it. I have to use Excel, if you can use that I would appreciate thank you.

Please help, The first part is how to do it. I have to use Excel, if you can use that I would appreciate thank you. Please help, The first part is how to do it. IPlease help, The first part is how to do it. I

1. Linear Trendlines (See this link for trendline help): Using the data set given in Excel Supplement Part 1, we want to show that the beam deflection, given in millimeters, is linearly dependent on the load, given in Newtons. This means deflection will be plotted as a function of load. In other words, the deflection will be measured along the y-axis and the load will be measured along the x-axis. a. Add a linear curve fit of the plotted data with the line going through the origin by adding a linear Trendline element to your chart and setting the intercept of that line to zero (i.e., make sure Set Intercept" is selected and equal to 0). b. Display the linear trendline equation on the chart (i.e., Display Equation on chart" is selected). Display the equation's slope to 3 decimal places (select Category: Number and Decimal places: 3). C. Make sure your chart's axes and title are appropriately labeled. Include units with your axis labels. Do not display a legend. For the Chart title, put your last name in the title (e.g., Compton's Beam Deflection versus Load) Compton's Beam Deflection versus Load 35 y 0.624 2.5 815 10 05 00 10 15 2.0 SO Part 1 Chart Excel Charts Project Part 1 1. Create a scatter chart with the data in blue as described in the Excel Chart Project handout 2. For the Chart title, put your last name in the title (e.g., Compton's Beam Deflection versus Load) Beam Deflections Mass (m) Load (W) Deflection (g) (N) (mm) 0 0.000 0.000 100 0.981 0.700 200 1.962 1.295 300 2.943 1.775 400 3.924 2.440 500 4.905 3.060

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 General Management Questions!