NEU Postgresql Installation and Database Queries Research Paper

Im working on a Software Development question and need guidance to help me study.

Exercise 1: Histogram

Exercise 1 in the text: You may use any spreadsheet program. Submit a Word document with a screenshot from your computer showing the histogram. Comment your images with a sentence or so of description 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.

Execise 2: Calculating Quartiles

Exercise 2 from the text: Use any spreadsheet program. Submit a Word document showing a screen shot from your computer with the quartiles underlined or highlighted. Comment your images with a sentence or so of description 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.

Exercise 3: Central Tendency

Exercise 3: Use any spreadsheet program. Submit a Word document with a screen shot from your computer showing the highlighted median. Comment your images with a sentence or so of description 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.

Exercise 4: Dispersion

Exercise 4: Use any spreadsheet program. Using the data provided in the text, submit a Word document with a screen shot from your computer highlighting the range, standard deviation, IQR, and outliers of Add-on Sales. Comment your images so the viewer knows 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.

Exercise 5: Pearson Correlation

Exercise 5: Use any spreadsheet program. Using the data provided in the text, create a scatter plot and calculate the Pearson Correlation Coefficient. Comment your images with a sentence or so of description 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.

Exercise 10: Using Joins

Using the sqla database, connect the sales and customers databases to obtain a list of customers who bought a car.

Submit a Word document with the results of the successful query. Comment your images with a sentence or so of description 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.

Exercise 11: using UNION

Using sqlda, do the UNION query described in the text. Submit a Word document with a screenshot of the result. Comment your images with a sentence or so of description 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.

Exercise 12: CASE Statement

1. using sqlda, create a query that will add a region column to the customer id according to the ranges provided in the text.

Submit a screen shot of the successful query. Comment your images with a sentence or so of description 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.

Activity 5: Sales Model

Complete Activity 5 as described in the text. Submit a screen shot of your output. This is a complex query that provides a variety of columns in the result including a new column that identifies the transaction as one of ‘high savings’. What command will you use to accomplish this? Comment your images with a sentence or so of description 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.

Activity 2: Exploring Sales Data

There is no activity 1.

Activity 2: Use the attached dealerships.csv file and any spreadsheet program. Submit a Word document with a screen shot from your computer of your solutions to questions 2 – 7 in the text. Highlight your results. Comment your images with a sentence or so of description 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.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}