1. Engineering
  2. Mechanical Engineering
  3. i did the first part creating trendline but i need...

Question: i did the first part creating trendline but i need...

Question details

Question 1: For the data set provided, create an Excel scatter chart with trendline. Show the trendline equation and goodness of fit R2 on the chart. From the trendline equation, determine the value a if we know the below model equation applies: 2 D

I did the first part creating trendline but I need help figureing out the a from the equation. I need to create this file on excel so I need steps to get the solution as well. Thank you

D C
cm cm
2.0 6.13
2.2 6.88
2.7 8.55
2.9 8.95
3.3 10.50
4.0 12.26
4.6 14.40
5.1 16.01
5.8 18.61
6.0 18.76
6.5 20.55
6.8 20.99
7.1 22.24
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution