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
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.

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}$$.