Based on the source data that was selected prior to running our analysis on the excel spreadsheet we duly recorded in excess of seventy observations that showcased the revenue of our industry data sets. The data sets were then isolated into two specific categories:
Industry Performance Revenue
Industry Outlook Revenue
Both sets of data was then compartmentalized into a summary of two tables that showcased the characteristics of the entire data set in question. To achieve these summarized results Microsoft excel was used and the revenue was displayed as a mean of all the values and also as an arithmetic sum. The metrics of growth rate were also calculated and following results were achieved:
Delegate your assignment to our experts and they will do the rest.
Industry Performance Revenue
|
Average (Revenue Growth) |
3,126,344,329.90 |
| Sum (Revenue Growth) |
303,255,400,000.00 |
| Average of Growth Percentage (%) |
0.91 |
Industry Outlook Revenue
| Average (Revenue Growth) |
232,363,144.24 |
| Sum (Revenue Growth) |
16,497,783,241.00 |
| Average of Growth Percentage (%) |
22.00 |
These results were acquired by running the arithmetic mean formula (=average[range]), the arithmetic sum formula (=sum[range]) and the growth rate formula (=[[[cell/lower cell] * 100] -100]. For a complete analysis on how specifically this was done, please refer to the attached excel spreadsheet along with this brief report.
