subject

Copy the attached dataset into your sqlda database. Find the MAX and MIN percentages of users by zip code. Using JOINs calculate the sales amounts for customers who live in high public transportation use areas and low public transportation use areas (Case statements). Calculate the average sales in those areas. Plot a histogram of the data in R or in Python. Group customers based on their public transportation usage and count the average number of transactions per customer. Export this data and create a scatterplot in R or Python. Discuss any recommendations you deduce from the plot. Submit a Word document with screenshots of your successful query, your histogram, and your scatter plot. Write your recommendation after the screenshots. Describe in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 17:20
Find the inverse function of f(x)= 1+squareroot of 1+2x
Answers: 2
question
Computers and Technology, 22.06.2019 18:00
Budgets you to do all of the following expect a) send frivolously b) avoid over spending c) gain financial independence d) examine your priorities and goals
Answers: 2
question
Computers and Technology, 24.06.2019 13:00
George heard about the benefits of a data warehouse. he wants to try implementing one for his organization. however, he is afraid that transferring data to the data warehouse will affect transaction time. which element ensures that transactions are not affected when moving data to a warehouse? when data is transferred to a data warehouse, the a area frees the source system to continue transaction processing.
Answers: 2
question
Computers and Technology, 26.06.2019 09:00
Businesses use a fax cover sheet is to provide detailed service and product information make sure message reaches the right recipient let recipient know the topic of the fax ensure safe communication convey subtle messages
Answers: 1
You know the right answer?
Copy the attached dataset into your sqlda database. Find the MAX and MIN percentages of users by zip...
Questions
question
History, 09.03.2021 18:50
question
Mathematics, 09.03.2021 18:50
question
Mathematics, 09.03.2021 18:50
question
Mathematics, 09.03.2021 18:50
question
Mathematics, 09.03.2021 18:50
Questions on the website: 13722359