Suppose that you have cut circles of different diameters from the same uniform sheet of paper.You...

Suppose that you have cut circles of different diameters from the same uniform sheet of paper.You measure the diameter and mass of each circle and collect the following data:

Mass of Circles as a Function of DiameterD (cm) (m) (g)10.0 0.624 12.0 0.886 14.0 1.148 16.0 1.429 18.0 1.859 20.0 2.307

As an exercise you will now make a graph of vs. in Excel. Note that when you are asked to make a graph in the form " vs ", the first variable mentioned is graphed on the vertical axis and the second variable is graphed on the horizontal axis. To complete the following exercises youwill need to explore the Excel menu system, you may get help from another student or me whennecessary. Note that when you right-click on most items a contextual menu will appear.1. Enter the values in column-A (which is horizontal by default) and the values in column-B (which is vertical by default). Start your entries in Row-3 so you can produce a table similar tothe one above that has a title and column headings.2. Select your data and use the Excel "Chart" feature to turn this into a "Marked Scatter" graph.You do not want to connect the points with any curve at this time.3. Remove any reference to "Series-1" that may appear on your graph by clicking on it anddeleting it. The graph will resize.4. By default Excel shows horizontal grid lines. See if you can insert vertical grid lines too.5. Add the chart title "Mass of Circles as a Function of Diameter" above the chart.6. Add the horizontal axis title "D (cm)" below the horizontal axis.7. Add a rotated vertical axis title "m (g)" to the left of the vertical axis.8. Add a second-order polynomial trend-line to the chart. Select the "Display equation on chart"and "Display R-squared value on chart" options.9. Force Excel to display the polynomial coefficients to 6 decimal places.

Solutions

Expert Solution

Solution:

The data corresponding to the mass of the circle as a function of its diameter is given as follows

Diameter, D (cm)	Mass, m (g)
10.0	0.624
12.0	0.886
14.0	1.148
16.0	1.429
18.0	1.859
20.0	2.307

A graph is plotted between the diameter of the circle and mass with the help of excel and is shown below.

Here, we have taken the diameter on the x-axis and the mass on the y-axis and is fitted with the second-order polynomial and the corresponding equation is shown on the graph.

Here, the blue solid circles represent the data points and the solid red line represents the second-order polynomial fit to the given data.

It shows that the data is properly fitted with the second-order polynomial resulting a good R² values (close to 1).

The equation with which we have fitted the data is given below.

The same equation we can write in terms of the mass of the circle as a function of its diameter as follows

Where

Hence, we have expressed the mass of the circle as a function of its diameter.

genius_generous answered 1 year ago

Next > < Previous

Related Solutions

a. If you have two chromatograms of the same mixture, but they are from two different...

a. If you have two chromatograms of the same mixture, but they are from two different GC instruments, then how do you determine which one gives you better separation. For example, if the first one gives short, broad peaks and the 2nd one gives tall, sharp peaks then which instrument gives you better separation? Explain your answer. b. What is the retention time of peaks in the Gas Chromatograph tell you about the compound? For example, if you have a...

1.) A sheet of paper is cut into 6 same-size parts. Each of the parts is...

1.) A sheet of paper is cut into 6 same-size parts. Each of the parts is then cut into 6 same-size parts and so on. a. After the 8th cut, how many of the smallest pieces of paper are there? b. After the nth cut, how many of the smallest pieces of paper are there? 2.) Find the sum of the sequence 5+15+25+35+...65 3.)How many terms are there in each of the following sequences? a. 1,2,22,23,...2299 b.9,13,17,21,...329 c.32,33,34,35,...432

Why do different drugs have different ranges of diameters that lead to assignment of Resistant, Intermediate...

Why do different drugs have different ranges of diameters that lead to assignment of Resistant, Intermediate or Susceptible as the outcomes for each test? (For example, why is a strain diagnosed as streptomycin resistant when the diameter is 11 mm or less around a streptomycin disk, but determined to be tetracycline resistant if the diameter is 14 mm or less around the tetracycline disk? See image below for example) What does it mean if there is no zone of inhibition...

Imagine you have a plasmid and you cut it with three different restriction enzymes (enzymes 1,...

Imagine you have a plasmid and you cut it with three different restriction enzymes (enzymes 1, 2, 3). You then run these fragments through a gel and get this separation. Label the positive and negative terminals on this gel with a (+) and (-) sign. If you were working with a single plasmid, how many cut sites did restriction enzyme 1 have? Explain? When creating a gel, we stain it with Ethidium Bromide or Gel Red. What is the purpose...

From a rectangular sheet measuring 250?? by 150??, equal squares of side ? are cut from...

From a rectangular sheet measuring 250?? by 150??, equal squares of side ? are cut from each of the four corners. The remaining flaps are then folded upwards to form an open box Find the value of x that gives the maximum volume and give your answer to 2 decimal places. Xmax= Calculate the volume to the nearest ??3. Vmax=

Suppose there are two countries that have the same nominal GDP. Do they have the same...

Suppose there are two countries that have the same nominal GDP. Do they have the same standard of living? Why or why not? Scenario 2: Suppose there are two countries and nominal GDP in one country is twice as large as the other country. Do they have the same standard of living? Why or why not?

Suppose you have a wire of length L. You cut a length x to make a square and use the remaining

Suppose you have a wire of length L. You cut a length x to make a square and use the remaining length L - x to make a circle. Use MuPAD to find the length x that maximizes the sum of the areas enclosed by the square and the circle.

Two pendulums have the same length but different masses. If m1 is released from the position...

Two pendulums have the same length but different masses. If m1 is released from the position shown in the figure on the right, how high would the masses reach after the collision (a) assuming a perfectly inelastic collision, and (b) perfectly elastic collision. Use m1(green) = 100g, m2 (purple) = 150g, and angle = 40 degrees, Length 1 & 2 = 0.5 m.

Suppose you have access to a random number generator Rng() that generates uniform random numbers in...

Suppose you have access to a random number generator Rng() that generates uniform random numbers in {0, 1, . . . , n − 1}. Design a function uses Rng() generate a uniform random number in {0, 1, . . . , m − 1}, where m ≤ n

1.i) Suppose that there are many different companies whose stocks have the same beta, say 1....

1.i) Suppose that there are many different companies whose stocks have the same beta, say 1. Can you form a portfolio to diversify the risk to get a lower beta? ii) Single factor model. Suppose that the single factor model for stocks A and B is estimated from excess returns as follows ReA = 3% + 0.7ReM + εA ReB = −2% + 1.2ReM + εB where, σM = 20% , R-squared of A is 20% and R-squared of B...

Subjects