BIS 445 Business Intelligence and Data Analysis Week 5 Lab Solution – Homeworkmade

DOWNLOAD: BIS 445 Business Intelligence and Data Analysis Week 5 Lab Solution – Homeworkmade

BIS 445 Week 5 Lab

Using Lab 5 provide copies of your screen shots or answer the questions for each Section listed below

Part A: Use import wizard to import comma delimited file into a SQL 2008 table

a.Paste your screen shot of your final Import wizard results here

Part B: Create scatter plots

a.Paste your screen shot of your scatter plot for food court drink sales here:

b.Paste your screenshot of your scatter plot for street vendor drink sales here:

Part C: Regression analyses

a.Paste your screen shot on your regression analysis on period number and food court drink sales here :

b.Paste your screen shot on your regression analysis on period number and street drink sales here (include all of your regression analysis results including the above:

c.What is the equation of the line of best fit for period and mall drink sales (answer below):

d.Do you think period number is a good predictor of street drink sales? Justify your reasons with answers from your linear regression output. Refer to at least two

statistics in your answer