Data Set: Heavenly Chocolate

Data Set: Heavenly Chocolate
Heavenly Chocolate manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago the company developed a website and began selling its products over the internet. Website sales have exceeded the company’s expectations, and management is now considering strategies to increase sales even further. To learn more about the website customers, a sample of 50 Heavenly Chocolate transactions was selected from the previous month’s sales, and the following data were recorded.
Description of the variables
Customers: the control number of customers that were part of the sample
Day: the day of the week each transaction was made
Browser: the type of browser customers used
Time (min): the time in minutes spent on the website
Page viewed: the number of website pages viewed per visit
Amount spent ($): the dollar amount spent per transaction
The data set, as you may recall, contains a sample of 50 Heavenly Chocolates website transactions. Complete the following tasks to learn more about the online customers who visited Heavenly Chocolate Company’s website.

* Given the two quantitative variables (Page viewed and Amount spent) in Part B, identify which of them should be considered as an independent variable. Then, create a scatter plot for the number of website pages viewed per visit and the dollar amount spent per transaction. (Make sure that the independent variable you identified will be assigned on the horizontal axis.)
* Find the linear regression model (the equation of a linear regression line)
for the two quantitative variables in Part C. Identify the slope and y-intercept of the model after you round the values to two decimal places.

I have already done part b I have included my answer below:

PART B

Based on the Heavenly Chocolate data sample the correlation coefficient shows the value of R between the page viewed and amount spent: 0,7169 ≈ 0,717. This value presents us that there is moderate positive correlation, which means there is a tendency for high X variable scores go with high Y variable scores and vice versa. In effect, this suggests that when the page viewed number increases there is a high tendency for amount spent to increase as well.

I have included the excel data needed to be used for the assignment

Last Completed Projects