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, 23.06.2019 07:30
What is the original authority for copyright laws
Answers: 1
question
Computers and Technology, 23.06.2019 11:30
In cell h5 enter a formula that will calculate the percentage of attendees that went to the altamonte springs job fair in 2018.
Answers: 1
question
Computers and Technology, 23.06.2019 13:00
Which of the following statements is false? a. a class can directly inherit from class object. b. if the class you're inheriting from declares instance variables as private, the inherited class can access those instance variables directly. c. a class's instance variables are normally declared private to enforce good software engineering. d. it's often much more efficient to create a class by inheriting from a similar class than to create the class by writing every line of code the new class requires.
Answers: 3
question
Computers and Technology, 23.06.2019 20:50
3.11.3 quiz: comparing and analyzing function typesquestion 4 of 102 pointswhat can you say about the y-values of the two functions f(x) = 3x2-3 andg(x)=2* - 3?
Answers: 2
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
Mathematics, 20.09.2020 09:01
question
Health, 20.09.2020 09:01
question
History, 20.09.2020 09:01
question
Mathematics, 20.09.2020 09:01
question
Mathematics, 20.09.2020 09:01
Questions on the website: 13722362