Data Set S&P 500 Index Variable GICS Sector GICS Sector Qualitative/Nonnumeric Observations 500 Missing 0 Values 500 Frequency Utilities: 6.2% Telecommunications Services: 1 GICS Sector Energy: 7.8% Materials: 5.8% Infomation Technology: 14,4% Variable Bar Chart Pie Chart Financials: 17.6% Variable Correlation Correlation Industrials: 11.0% Consumer Descretionary: 16. Health Care: 10.4% Consumer Staples: 8.2% Using the tool, make a pie chart of the percent frequency distribution of the S&P 500 companies according to their GICS sectors. Cli Variable sliding panels on the left side of the tool screen, and select the variable GICS Sector. Then click on the Pie Chart button. What is the percent frequency of S&P 500 companies in the Utilities sector? 4 6.2% 5.8% 0.062% O 7.8% On the pie chart, the wedge representing this sector has an angle of 30 degrees (rounded to the nearest degree). The S&P 100 Index lists 100 leading U.S. stocks with exchange-listed options. It was developed by the Chicago Board of Options Exc and later transferred to S&P. The constituents of the S&P 100 form a subset of the S&P 500 and are among its largest and most estall companies. Variable Variable Gacs Sector S&P 100 GICS Sector Utilities: 5.0% Telecomunicats Sevas 18 Information Technology 11.0. GICS Sector Energy: 9.0% Materials: 5.0% Qualitative/Nonnumeric Observations-500 Missing 01 Values-500 Frequency Bar Chart Variable Correlation Correlation Pie Chart Financials: 18.01 Health Care: 11.0 Filter: S&P 100-In S&P 100 Industrials: 13.0% Consumer Discretionary Consumer Staples: 14.0% Use this second tool to make a pie chart of the percent frequency distribution of the S&P 100 companies according to their GICS sectors. (Hint: Before creating the pie chart, use the variable S&P 100 to filter out all the companies that are not in the S&P 100. To do this, click on one of the Variable sliding panels on the left side of the tool screen, and select the variable S&P 100. The second column shown is labeled Filter. To exclude companies that are not in the S&P 100, click to remove the X in the box next to the category Not in S&P 100. Then proceed by clicking on another of the Variable sliding panels, selecting the variable GICS Sector, and clicking on the Pie Chart button.) What is the percent frequency of S&P 100 companies in the Utilities sector? 5.0% 6.2% 6.0% 0.05% According to GICS specifications, companies in the Consumer Discretionary sector-such as those in the leisure and entertainment industries; consumer retailing and services, or manufacture of household durable goods-are the most sensitive to economic cycles. Companies in the Consumer Staples sector-such as manufacturers and distributors of food, beverages, tobacco, and household nondurable goods--are less sensitive to economic cycles. Compare the percent frequencies for the Consumer Discretionary and Consumer Staples sectors in the preceding two pie charts. The percent frequency of S&P 100 companies in the Consumer Discretionary sector is the percent frequency of S&P 500 companies in the same sector. The percent frequency for S&P 100 companies in the Consumer Staples sector is the percent frequency of S&P 500 companies in the same sector. The percent frequency of S&P 100 companies in the combined sectors (Consumer Discretionary and Consumer Staples) the percent frequency of S&P 500 companies in the two sectors