2. (LO 2.3) Northwind Traders is a fictitious specialty foods company created by Microsoft, which has also created a fictitious database for the company. The Northwind database includes several tables, including Products, Suppliers, and Categories. Pictured below is a subset of the Products table, which details all the products that Northwind Traders sells. ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued 10 boxes x 20 Chai Chang Aniseed Syrup Chef Anton's Cajun Seasoning 1 1 1 2 1 bags 24-12 oz 1 bottles 12 - 550 ml 2 bottles 2 48-6 oz jars 18 19 10 22 39 17 13 53 0 40 70 0 10 25 25 0 b. If you averaged everything in the SupplierID field, would you obtain a useful number? Explain. c. If you averaged UnitPrice, would you obtain a useful number? Explain. 0 0 0 0 a. Review each variable in the Products table. Which would be classified as numerical data-that is, data that would be interesting to add or average?

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question
100%
2. (LO 2.3) Northwind Traders is a fictitious specialty foods company created by Microsoft, which has also created a fictitious
database for the company. The Northwind database includes several tables, including Products, Suppliers, and Categories.
Pictured below is a subset of the Products table, which details all the products that Northwind Traders sells.
ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued
10 boxes x 20
Chai
Chang
Aniseed
Syrup
Chef Anton's
Cajun
Seasoning
1
1
1
2
1 bags
24-12 oz
1 bottles
12- 550 ml
2 bottles
2 48-6 oz jars
18
19
10
22
39
17
13
53
0
40
70
10
25
25
0
b. If you averaged everything in the SupplierlD field, would you obtain a useful number? Explain.
c. If you averaged UnitPrice, would you obtain a useful number? Explain.
0
0
0
0
a. Review each variable in the Products table. Which would be classified as numerical data-that is, data that would be
interesting to add or average?
Transcribed Image Text:2. (LO 2.3) Northwind Traders is a fictitious specialty foods company created by Microsoft, which has also created a fictitious database for the company. The Northwind database includes several tables, including Products, Suppliers, and Categories. Pictured below is a subset of the Products table, which details all the products that Northwind Traders sells. ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued 10 boxes x 20 Chai Chang Aniseed Syrup Chef Anton's Cajun Seasoning 1 1 1 2 1 bags 24-12 oz 1 bottles 12- 550 ml 2 bottles 2 48-6 oz jars 18 19 10 22 39 17 13 53 0 40 70 10 25 25 0 b. If you averaged everything in the SupplierlD field, would you obtain a useful number? Explain. c. If you averaged UnitPrice, would you obtain a useful number? Explain. 0 0 0 0 a. Review each variable in the Products table. Which would be classified as numerical data-that is, data that would be interesting to add or average?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Market for Pharmaceuticals
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education