# Data collected to analyze website sales: determine how you would lay out these data

944 Views

When you organize data in a​ spreadsheet, it is important to lay it out as a data table. For the example​ below, determine how you would lay out these data. Indicate the headings of columns and what would be found in each row.

Data collected to analyze website sales​: account #​, average item cost left parenthesis in \$ right parenthesis​, customer's rating left parenthesis 1 dash 10 right parentheses​, area code

In​ general, the rows of a data table correspond to individual cases about which some characteristics called variables are recorded. A case is the entity about whom or which data are recorded.

ANS:

Each row is an account.Columns hold the account # ​(to identify the​ row), the average item cost left parenthesis in \$ right parenthesis​, the customer's rating left parenthesis 1 dash 10 right parenthesis, and the area code.

Use this Example:

Data collected to analyze book sales​: average critic rating left parenthesis 1 to 4 stars right parenthesis​, total profit left parenthesis in \$ right parenthesis​, book title​, number of pages
Each row is a book because each book is an individual case about which the other information has been recorded. One of the columns should be the book title to identify the row.

The characteristics recorded about each individual or case are called variables. These are usually shown as the columns of a data​ table, and they should have a name that identifies what has been measured.

Note that there should be four different columns since there are four​ variables, average critic rating left parenthesis 1 to 4 stars right parenthesis​, total profit left parenthesis in \$ right parenthesis​, book title
​, and number of pages.

Thus, each row is a book.
There should be four columns. Columns hold the book title ​(to identify the​ row), the average critic rating left parenthesis 1 to 4 stars right parenthesis
​, the total profit left parenthesis in \$ right parenthesis​, and the number of pages
.