In exploration 2.1.3, you designed a data collection form and a questionnaire form for Beef n’ Buns. Set up a spreadsheet to capture data from these forms. Create fake data consistent with your data collection forms and enter these data into two separate data forms, one will be for the observational data and one for the survey data. Create comments for each variable name on the spreadsheet itself (as in example 6), stating its units or categories. Rename each of the sheets in the workbook with an appropriate title. Include at least ten observations of each variable. Use the space below to span and record your thoughts.
Planning form for the observational data
A | B | C | D | E | F | |
1 |
|
|
|
|
| |
2 |
|
|
|
|
|
|
3 |
|
|
|
|
| |
4 |
|
|
|
|
|
|
5 |
|
|
|
|
| |
6 |
|
|
|
|
|
|
Planning form for the survey data
A | B | C | D | E | F | |
1 |
|
|
|
|
| |
2 |
|
|
|
|
|
|
3 |
|
|
|
|
| |
4 |
|
|
|
|
|
|
5 |
|
|
|
|
| |
6 |
|
|
|
|
|
|