Create a function called genStats that computes statistics f

Create a function called genStats that computes statistics for a set of experimental runs. The data are stored in an Excel file, and genStats will compute statistics, then write the data together with the statistics in another Excel file. Assume a format similar to the first row is a header row, and the first column a list of team names. There may be any number of teams and each team may have any number of trials, but you may assume that there will be at least one team and at least one trial per team. genStats will accept as input the name of the Excel file, and will produce no output. It will perform the following steps: Calculate the average score for each team (each row), and store it in a new column called Average to the right of the rightmost trial column. Calculate the deviation for each team, and store it in a new column called Deviation to the right of the Average column. Deviation is the difference of each average from the maximum average, as computed in part a. It is not standard deviation! Calculate the average of each trial (each column), as well as the average of averages and the average deviation, and store it beneath the bottom row of the data. The name of the bottom row (what goes in the Team column) is Total Average. Write the original data plus new data to an Excel file called Stats_.xlsx. For instance, if the original file were called ScoreData.xIsx, the new file should be called Stats_ScoreData.xlsx.

Solution

I am giving the link of my own excel sheet so you can download from that web address.

https://drive.google.com/file/d/0B1cD-jFpARUbLVFBcWRyenlUblk/view?usp=drivesdk