Develop a spreadsheet model for Classify each of the data elements in the Sales Transactions database (Figure

Question:

Develop a spreadsheet model for Classify each of the data elements in the Sales Transactions database (Figure 1.1) as categorical, ordinal, interval, or ratio data and explain why. Apply the principles of spreadsheet engineering in developing your model. Use the spreadsheet to create a table for a range of prices to help you identify the price that results in the maximum revenue.

Figure 1.1

1 Sales Transactions: July 14 3 Cust ID Region Payment Раypal Credit Transaction Code Source Amount Product Time Of Day 4 10001 East 93816545 Web $20.19 DVD 22:19 13:27 14:27 5 10002 West 10003 North 10004 West 74083490 Web $17.85 DVD $23.98 DVD $23.51 Book $15.33 Book $17.30 DVD $177.72