b) Utilizing the worksheet Problem 6a, use the Regression tool in the Data Analysis Toolpack to perform a simple linear regression with the dependent variable (Y) = Sales and the explanatory variable (X) = Price. Use labels and output the regression results in a new worksheet and include standardized residuals. Name the new worksheet Prob6bSimpReg and locate this worksheet next to the Problem 6a worksheet (click and drag the worksheet tab). Change the numeric format for the p-value for the intercept to 'number' with 5 (.00000) decimal places so it is easier to read. Also create/make a histogram of the standardized residuals (hint: see P. 301). Now, go to the worksheet titled SimpRegMultChoice and answer the multiple choice questions based on the regression results & chart you generated. (NOTE: You do not need to save the histogram. You DO need to save the regression results!)

Market Region	Sales	Price	Competitor Price
1	2280	$220	$220
2	2160	$270	$290
3	2330	$240	$240
4	2070	$290	$260
5	2160	$280	$240
6	2470	$220	$250
7	2330	$200	$220
8	2490	$230	$270
9	2390	$210	$240
10	2090	$270	$240
11	2140	$280	$240
12	2360	$260	$300
13	2180	$260	$210
14	1910	$290	$220
15	2230	$260	$300