Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Subject: FUNDAMENTALS OF BUSINESS ANALYTICS Problem: The Supermarket contains over 14,000 transactions made by supermarket customers over a period of approximately two years. (The data are not real, but real supermarket chains have huge data sets just like this one.) A small sample of the data appears in in the Figure below, Column B contains the date of the purchase, column C is a unique identifier for each customer, columns D–H contain information about the customer, columns I–K contain the location of the store, columns L–N contain information about the product purchased (these columns have been hidden to conserve space), and the last two columns indicate the number of items purchased and the amount paid. Question: Based on the given problem and picture provided, determine which variables are categorical and numerical?

Subject: FUNDAMENTALS OF BUSINESS ANALYTICS Problem: The Supermarket contains over 14,000 transactions made by supermarket customers over a period of approximately two years. (The data are not real, but real supermarket chains have huge data sets just like this one.) A small sample of the data appears in in the Figure below, Column B contains the date of the purchase, column C is a unique identifier for each customer, columns D–H contain information about the customer, columns I–K contain the location of the store, columns L–N contain information about the product purchased (these columns have been hidden to conserve space), and the last two columns indicate the number of items purchased and the amount paid. Question: Based on the given problem and picture provided, determine which variables are categorical and numerical?

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question

Subject: FUNDAMENTALS OF BUSINESS ANALYTICS

Problem: The Supermarket contains over 14,000 transactions made by supermarket customers over a period of approximately two years. (The data are not real, but real supermarket chains have huge data sets just like this one.) A small sample of the data appears in in the Figure below, Column B contains the date of the purchase, column C is a unique identifier for each customer, columns D–H contain information about the customer, columns I–K contain the location of the store, columns L–N contain information about the product purchased (these columns have been hidden to conserve space), and the last two columns indicate the number of items purchased and the amount paid.

Question: Based on the given problem and picture provided, determine which variables are categorical and numerical?

A В D E F K P Purchase Customer Marital Home State or Units 1 Transaction Date Province Country Gender Status Owner Children Annual Income City Los Angeles Los Angeles ID Sold Revenue 12/18/2011 12/20/2011 $27.38 $14.90 1 7223 F S Y 2 $30K - $50K CA USA 5 5 $7OK - $90K 2 $50K - $70K 3 $30K - $50K 3 $130K - $150K Beverly Hills 3 $10K - $30K 7841 M M Y CA USA 12/21/2011 12/21/2011 4 3 8374 F M Bremerton WA USA 3 $5.52 $4.44 $14.00 $4.37 4 9619 M M Y Portland OR USA 4 12/22/2011 12/22/2011 12/23/2011 1900 F S Y СА USA 4 7 6. 6696 F M Y Beverly Hills СА USA 3 7 9673 2 $30K - $50K Salem OR USA 4 $13.78 8 12/25/2011 354 F M 2 $150K + Yakima WA USA $7.34 3 $10K - $30K 1 $50K - $70K 10 12/25/2011 1293 M M Y Bellingham WA USA 1 $2.41 11 10 12/25/2011 7938 M S N San Diego CA USA 2 $8.96
Transcribed Image Text:A В D E F K P Purchase Customer Marital Home State or Units 1 Transaction Date Province Country Gender Status Owner Children Annual Income City Los Angeles Los Angeles ID Sold Revenue 12/18/2011 12/20/2011 $27.38 $14.90 1 7223 F S Y 2 $30K - $50K CA USA 5 5 $7OK - $90K 2 $50K - $70K 3 $30K - $50K 3 $130K - $150K Beverly Hills 3 $10K - $30K 7841 M M Y CA USA 12/21/2011 12/21/2011 4 3 8374 F M Bremerton WA USA 3 $5.52 $4.44 $14.00 $4.37 4 9619 M M Y Portland OR USA 4 12/22/2011 12/22/2011 12/23/2011 1900 F S Y СА USA 4 7 6. 6696 F M Y Beverly Hills СА USA 3 7 9673 2 $30K - $50K Salem OR USA 4 $13.78 8 12/25/2011 354 F M 2 $150K + Yakima WA USA $7.34 3 $10K - $30K 1 $50K - $70K 10 12/25/2011 1293 M M Y Bellingham WA USA 1 $2.41 11 10 12/25/2011 7938 M S N San Diego CA USA 2 $8.96
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS