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.

boitshupoO

boitshupoO

Answered question

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.

Answer & Explanation

Roosevelt Houghton

Roosevelt Houghton

Skilled2021-01-14Added 106 answers

a. Since the shapes are all squares, the perimeter of the squares are 4s where ss is the side length and the areas are s2 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 =4×A4.
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 =A42.
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:

Do you have a similar question?

Recalculate according to your conditions!

New Questions in College Statistics

Ask your question.
Get an expert answer.

Let our experts help you. Answer in as fast as 15 minutes.

Didn't find what you were looking for?