Lab FX Quiz 27 Feb
pdf
keyboard_arrow_up
School
University of California, Berkeley *
*We aren’t endorsed by this school
Course
88
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
Pages
5
Uploaded by DeanBookKookabura6
Lab FX
Started: Feb 22 at 6:12pm
Quiz Instructions
Do your lab work on JupyterHub at ugba88-2023-spring.haastech.org. Then save your lab work to
your local computer or share drive in PDF format. Then answer these numerical and multiple-
choice questions related to the lab work here. Also, upload a copy of your lab work in PDF format
here.
Express your numerical answers with two decimal places, e.g., 3.14, -123.45, 0.01 . 1 pts
Question 1
20,212
There are ____
observations or rows in the entire kona_sales data table.
1 pts
Question 2
transaction_hour
none of these
transaction_time
sales_outlet_id
transaction_date
customer_id
staff_id
Which is the smallest set of attributes or variables that you need to uniquely
distinguish a store receipt in the database. Select all that apply.
transaction_id
instore_yn
1 pts
Question 3
17,071
There are ___ observations or rows from Store 8.
1 pts
Question 4
94,823.6
The total revenue in the database is ___.
1 pts
Question 5
79,528.25
The total revenue from just Store 8 is ____. 1 pts
Question 6
The number of distinct customers in the loyalty program who have made
purchases is (subtract one for customer_id = 0) ____.
1,164
1 pts
Question 7
16,041
The number of distinct receipts in the database is ___.
1 pts
Question 8
54.75
What is the total revenue from the fifth most expensive receipt in the database
(the fifth largest total line_item_amount):____.
1 pts
Question 9
48
What is the total revenue from the fifth most expensive receipt in the database
(the fifth largest total line_item_amount) if we only consider customers in the
loyalty program: ___.
1 pts
Question 10
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
5.91
What is average amount spent on a receipt (not limited to store 8)___.
1 pts
Question 11
1.8
What is average number of items purchsaed on a receipt (not limited to store 8)
___.
1 pts
Question 12
397
How many distinct customers (in the loyalty program) visited Store 8 in week 16
(subtract one for customer_id = 0) ___.
1 pts
Question 13
645
How many distinct customers in (in the loyalty program) visited across all stores
in the database in week 17 (subtract one for customer_id = 0) ___.
Quiz saved at 12:42pm
1 pts
Question 14
488
How many receipts were collected on day 5 across all stores and all customers
___.
1 pts
Question 15
213
How many "Drip coffee" purchases were made by "Baby Boomers" across all
time periods and all stores in the database___.
1 pts
Question 16
Upload
Please attach your Jupyter Notebook using the instructions on the
Jupyter Primer.
If you follow the instructions correctly, your code should be run
and the file path of your work should be reflected at the bottom of the notebook.
Choose a File
Submit Quiz