Chapter 13, Problem 1ICA

To determine

Show the resulting data and trend lines, with equation and $R^2$ value using either rectilinear, semilog or log-log graph.

Answer to Problem 1ICA

The data and trend line with equation and $R^2$ value using log-log graph is shown in Figure 4.

Explanation of Solution

Description:

Step 1: Open the Excel Sheet, and enter the data as shown in Figure 1.

Step 2: Select all the data from columns Radius and Height.

Step 3: Now, go to the Insert tab in the Excel and click on the Scatter Plot.

Step 4: Change the property of the plot to get the linear plot as follows.

• Click on the y-axis, select format axis as shown in Figure 2.

• Similarly, click on the x-axis and format the axis.

Step 5: Click on points and add trendline as shown in Figure 3.

Step 6: Label the axis of the plot properly as per the format shown below.

$\text{Label}\text{format:Variable}\left(\text{symbol}\right)\left[\text{unit}\right]$.

Step 7: Mention the title of the plot as shown in Figure 4.

Conclusion:

Hence, the data and trend line with equation and $R^2$ value using log-log graph is shown in Figure 4.