Statisitical report Essay

1783 Words8 Pages
BU1007 Business Data Analysis and Interpretation Singapore Campus, Study Period SP53, 2013 Statistical Report Analysis of Case study 3: Heavenly Chocolates website transactions Prepared for Dr Tjong Budisantoso Done by Mr. Keung, Tseung Student ID : 12776910 20/12/2013 Table of contents Introduction --------------------------------------------------------------------------- Question a --------------------------------------------------------------------------- Question b…show more content…
Vice versa, the less time spent and page viewed, the less payment made. The total amount of transaction have reached two peak points recorded \$758.86 on Monday and \$925.43 on Friday. From Tuesday to Thursday, has a slight decline from \$414.86 to \$294.03. Furthermore, on both Saturday and Sunday, the transactions have a relative low amount compared to the rest of the days, recorded \$394.4 and \$222.15, respectively. c). You have to develop a scatter diagram and compute a simple correlation coefficient to explore the relationship between the number of pages viewed and the amount (\$) spent (use horizontal axis for the number of pages viewed). Correlations Analysis Step 1: Scatter Diagram: the amount (\$) spent and the number of pages viewed Independent variable: Number of pages viewed Dependent variable: Amount Spent Step 2: Elaboration The Scatter diagram illustrate a strong positive linear correlation and a direct relationship between the two variables. To apply the Coefficient of Correlation (r) formula: Correlation coefficient = 0.9(Solved by Excel) When r is close to 1, which proves it is a positive correlation, so there is a direct relationship can be seen between the number of pages viewed and the amount spent , and the value of 0.9 is rather close to 1.00, so it can be concluded that the