Please see attachment
Please refer to the attachment.
Thanks for using Brainmass.
[Please refer to the EXCEL attachment for Correlation Analysis, Scatter Plot Matrix and Regression Analysis]
The regression equation for Annual Sales [$000] is given as follows:
y=16.202 x_1+1.746 ...
The solution is comprised of detailed regression analysis pertaining to three problems related to Quantitative Analysis.