Solve the following problems using Microsoft Excel

blast 1. 50 Companies percentages of revenues spent on R&D are given below. 4.2 6.9 7.8 8.8 10.5 5.6 6.9 7.9 19 10.5 5.9 7.1 8 9.2 10.6 6.0 17.1 8 9.4 11.1 6.5 7.2 8.1 9.5 11.3 6.5 7.2 8.2 9.5 11.7 6.5 7.5 8.2 9.6 12.0 6.5 7.5 8.2 9.7 14 6.9 7.7 8.4 9.9 14.5 Find the following 6.9 7.7 8.5 10.1 15.5 Mean = Median= Mode= Range= Variance= Standard Deviation= Lower Quartile= Upper Quartile= Inter Quartile Range= Z Score for x = 12, x=8 First SD interval, Number of data 11 01 % of data Second SD interval Number of data % of data Third SD interval Number of data % of data Create a frequency distribution table with the 1st class interval as 4.0 - 6.0 Also include class relative frequency in the table Graph a Frequency histogram. Construct a Stem and Leaf display Calculate Q1, Q3 and Percentile rank for 8.2 and 65th percentile Check outlier, if any Answer the following using the above statistics i. How many companies spent between 6.0% to 10.0% for R & D. ii. What percentage of the companies spent above 10% on R & D. iii. Which is a better method to display this data and why? ( Total Marks 7)