Question

a. Complete the spreadsheet. b. What formula will you enter in cell B4? c. What formula will your enter in C4? d. Use the data in the spreadsheet to make the graphs below. Connect the points.

Analyzing categorical data
ANSWERED
asked 2021-01-13
a. Complete the spreadsheet.
b. What formula will you enter in cell B4?
c. What formula will your enter in C4?
d. Use the data in the spreadsheet to make the graphs below. Connect the points.

Answers (1)

2021-01-14
a. Since the shapes are all squares, the perimeter of the squares are 4s where ss is the side length and the areas are \(\displaystyle{s}^{{{2}}}\) where s is the side length. The spreadsheet is then completed as
b. B4 is the perimeter for a side of 1.5. Since the perimeter is 4 times the side length and the side length is in cell A4, the formula will be \(\displaystyle={4}\times{A}{4}\).
c. C4 is the area for a side of 1.5. Since the area is the square of the side length and the side length is in cell A4, the formula will be \(\displaystyle={A}{4}\wedge{2}\).
d. Plot the points (side, perimeter) from the spreadsheet and then connect the points with a line:
Plot the points (side, area) from the spreadsheet and then connect the points with a smooth curve:
0
 
Best answer

expert advice

Have a similar question?
We can deal with it in 3 hours

Relevant Questions

asked 2021-05-22
Sheila is in Ms. Cai's class . She noticed that the graph of the perimeter for the "dented square" in problem 3-61 was a line . "I wonder what the graph of its area looks like ," she said to her teammates .
a. Write an equation for the area of the "dented square" if xx represents the length of the large square and yy represents the area of the square.
b. On graph paper , graph the rule you found for the area in part (a). Why does a 1st−quadrant graph make sense for this situation? Are there other values of xx that cannot work in this situation? Be sure to include an indication of this on your graph, as necessary.
c. Explain to Sheila what the graph of the area looks like.
d. Use the graph to approximate xx when the area of the shape is 20 square units.
asked 2021-07-04
How can you use two way-frequency tables to analyze data?
asked 2021-05-21
The pmf of the amount of memory X (GB) in a purchased flash drive is given as the following.
\(\begin{array}{|c|c|}\hline x & 1 & 2 & 4 & 8 & 16 \\ \hline p(x) & 0.05 & 0.10 & 0.30 & 0.45 & 0.10 \\ \hline \end{array} \)
a) Compute E(X). (Enter your answer to two decimal places.) GB
b) Compute V(X) directly from the definition. (Enter your answer to four decimal places.) \(GB^{2}\)
c) Compute the standard deviation of X. (Round your answer to three decimal places.) GB
d) Compute V(X) using the shortcut formula. (Enter your answer to four decimal places.) \(GB^{2}\)
asked 2021-05-22
Describe the key characteristics of the graphs of rational functions of the form \(\displaystyle{f{{\left({x}\right)}}}=\frac{{{a}{x}+{b}}}{{{c}{x}+{d}}}\). Explain how you can determine these characteristics using the equations of the functions. In what ways are the graphs of all the functions in this family alike? In what ways are they different? Use examples in your comparison.
...