https://docs.google.com/spreadsheets/d/1HVjoEvTNc4q-Wulp_Br9hB83WLTIaQJ4oHmGwWYgTGI/edit?usp=sharing

The Excel sheet is too long to copy paste. If theres any other way to show the sheet id be more than happy to

Make a scatter plot of Price vs. Carat. Carat goes on the horizontal (x) axis, and Price goes on the vertical (y) axis.

3. Add a linear trendline with its equation andvalue. Make sure these are visible on the graph.

4. Answer the following questions on the second sheet of the Excel file. Answer in complete sentences. You will use the best fit line to determine your answers.

a. What is the correlation coefficient for the line? Is this a weak, moderate, or strong correlation? Explain how you know.

b. Use Interpolation to find the price of a diamond that is 0.47 carats. Show the steps.

c. Use Extrapolation to find the price of a diamond that is 1.2 carats in size. Show the steps.

d. Would it make sense to use this model to find the price of a diamond that is 3 carats in size? Explain why or why not.

e. If a diamond costs $4550, use the best-fit line to find the diamond's size. Show the steps.