(1) Using the Excel file to calculate the Cost and Output in the spreadsheet “Da

(1) Using the Excel file to calculate the Cost and Output in the spreadsheet “Data”. Be careful, and you MUST show the Excel calculation rather than simply put a number in the cells. Otherwise, you will get ZERO even your values are all correct. I do not need the values, which I can easily find in the textbook. What we need is Excel calculation!!! (2) In the spreadsheet “Figure 5.1”, you can see I have inserted a graph (“Total visit” against “Total nursing hours”) there, which is an example. First, you replicate the Figure 5.1 (my example graph) and insert your own graph. Second, you need to graph “Total Cost” against “Total nursing hours” by yourself using the value in the “Data” you calculated. (Hint: you must use “Scatter (X, Y)” if you have only 2 factors. Otherwise, if you use the “Line” graph, your figure will be wrong). Be careful, this assignment should be in an “Excel” document! If you turn in a document with other versions (like word, pdf…etc.) than Excel, you will get ZERO.