Question: Required information Lab Note: The tools presented in this lab periodically change. Updated instructions, If applicable, can be found in the eBook and lab walkthrough


Required information Lab Note: The tools presented in this lab periodically change. Updated instructions, If applicable, can be found in the eBook and lab walkthrough videos in Connect. Case Summary. You are a brand-new analyst and you Just got assigned to work on the Dillard's account. So far you have analyzed the ER Dlagram to gain a bird's-eye vew of all the different tables and fields in the database, and you have explored the data In each table to gain a glimpse at sample values from each field and how they are all formatted. You also gained a little Insight Into the distribution of sample values across each field, but at this point you are ready to dig Into the data a bit more. Data: Dillard's sales data are avallable only on the University of Arkansas Remote Desktop (waltonlab.uark.edu). See your Instructor for login credentials. OQ1. Which field has the highest average (mean)? TRAN_AMT SALE_PRICE ORIG_PRICE They all have the same average OQ2 What is the maximum for ORIG_PRICE? Note: Round your answer to the nearest whole number. OQ3. What is the maximum for SALE_PRICE? Note: Round your answer to the nearest whole number. Required information Lab Note: The tools presented in this lab periodically change. Updated instructions, If applicable, can be found in the eBook and lab walkthrough videos in Connect. Case Summary. You are a brand-new analyst and you Just got assigned to work on the Dillard's account. So far you have analyzed the ER Dlagram to gain a bird's-eye vew of all the different tables and fields in the database, and you have explored the data In each table to gain a glimpse at sample values from each field and how they are all formatted. You also gained a little Insight Into the distribution of sample values across each field, but at this point you are ready to dig Into the data a bit more. Data: Dillard's sales data are avallable only on the University of Arkansas Remote Desktop (waltonlab.uark.edu). See your Instructor for login credentials. OQ1. Which field has the highest average (mean)? TRAN_AMT SALE_PRICE ORIG_PRICE They all have the same average OQ2 What is the maximum for ORIG_PRICE? Note: Round your answer to the nearest whole number. OQ3. What is the maximum for SALE_PRICE? Note: Round your answer to the nearest whole number
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
