Report Essay Example | Topics and Well Written Essays - 1500 words - 25

Report - Essay Example In order to design the spreadsheet model, a graph of cost of silver from both companies during the month and a spreadsheet for each company. From the spreadsheet model, it is clear that the company would order silver Rookstone Company. The company is selected because of relatively low cost. The total monthly cost of silver from Rookstone Company is 113.67 while the total cost of silver from Metal Direct Company is 116.66. The graph illustrates the relationship between the cost of silver and the number of order for the two companies. For example, the cost of silver for four orders is 35.08 from Metal Direct Company and 34.18 from the Rookstone Company. The fluctuation in prices can be explained by the value added tax charged for each order. The attached file provided information in regard to dimensions, weights of materials used. The file also provides information in regard to order, total weight, cost of silver, VAT charged and total cost per month. The data provided shows that there is moderate agreement between management team opinion and industry expert opinion with r=0.5636.the number of trips is the factor which mostly influences the estimated safety when using the transport system. The relationship can be estimated using the model below; Smith and Jones Company provided data on Transport Company with respect to Transport Company which provides a Light Rail Transport system in an urban area. The company is interested to know level of agreement between management team opinion and industry expert opinion in regard to priority in spending. The company also provided survey data to investigate factors which mostly influence how safe customers feel when travelling on the service. In order to determine the level of agreement, spearman’s rank correlation coefficient is used. The options re listed and values assigned in respect to each option as per the two groups.the difference in value of opinion is obtained and then squared. Thespearman’s