Utilizing the data set assigned to you (below) in the "data sets" folder. Identify the appropriate dependent variable from the columns listed (what are you trying to

measure?). Use Excel to run a correlation matrix and regression analysis.

From the correlation matrix state independent variables in descending order of strength of correlation and if the correlation is positive or negative for each variable.

After running the regression state the p-value and if the null hypothesis is accepted or rejected for each independent variable.

Explain your findings as if you were talking to someone who has never taken a statistics course (tell a story).

\table[[Sales,Ad Dollars,Number of accounts,\table[[Number of],[Competitors]],Potential],[79.3,5.5,31,10,8],[200.1,2.5,55,8,6],[163.2,8,67,12,9],[200.1,3,50,7,16],[146,3,38,8,15],[177.7,2.9,71,12,17],[30.9,8,30,12,8],[291.9,9,56,5,10],[160,4,42,8,4],[339.4,6.5,73,5,16],[159.6,5.5,60,11,7],[86.3,5,44,12,12],[237.5,6,50,6,6],[107.2,5,39,10,4],[155,3.5,55,10,4],[291.4,8,70,6,14],[100.2,6,40,11,6],[135.8,4,50,11,8],[223.3,7.5,62,9,13],[195,7,59,9,11],[73.4,6.7,53,13,5],[47.7,6.1,38,13,10],[140.7,3.6,43,9,17],[93.5,4.2,26,8,3],[259,4.5,75,8,19],[331.2,5.6,71,4,9]]