Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this discussion, you will apply the statistical concepts and techniques covered in this week's reading about one-way analysis of variance (ANOVA). An investment analyst

image text in transcribedimage text in transcribedimage text in transcribed
In this discussion, you will apply the statistical concepts and techniques covered in this week's reading about one-way analysis of variance (ANOVA). An investment analyst is evaluating the 10-year mean return on investment for industry-specific exchangetraded funds (ETFs) for three sectors: financial, energy, and technology. The analyst obtains a random sample of 30 ETFs for each sector and calculates the 10-year return of each ETF. The analyst has provided you with this data set. Run Step 1 in the Python script to upload the data file. Using the sample data, perform one-way analysis of variance (ANOVA). Evaluate whether the average return of at least one of the industry-specific ETFs is significantly different. Use a 5% level of significance. In your initial post, address the following items: 1. Define the null and alternative hypothesis in mathematical terms and in words. 2. Report the level of significance. 3. Include the test statistic and the P-value. See Step 2 in the Python script. 4. Provide your conclusion and interpretation of the test. Should the null hypothesis be rejected? Why or why not? 5. Does a side-by-side boxplot of the 10-year returns of ETFs from the three sectors confirm your conclusion of the hypothesis test? Why or why not? See Step 3 in the Python script. Step 1: Uploading the dataset The data for this discussion is included in a CSV file called etf_returns.csv. It contains ten-year returns of 30 ETFs for three sectors: financial, energy, and technology. The read_csv method in pandas can be used to upload the CSV. Click the block of code below and hit the Run button above. In [1] : import pandas as pd # read data from etf_returns. csv. etf returns_df = pd. read_csv( 'etf_returns . csv' ) # print etf returns data set. print (etf_returns_df ) financial energy technology 5.5 5.2 7.3 .1 7 . 4 8 . 2 6.9 5. 6 7.1 5. 1 5 . 7 7.6 1 . 6 5 .6 8 . 2 5.5 11.5 5 .9 ).4 9 . 2 5. 1 9 . 5 i. 2 7.3 7. 4 8. 2 . 9 6. 6 7. 1 5 . 1 5 . 7 7. 6 1. 6 5 . 6 8. 2 5.3 5.5 11.5 5.9 6. 4 9 .2 15 5 .6 6. 1 9. 5 16 4.7 4. 4 6. 2 17 6. 4 6.6 7.4 Step 2: Performing one-way ANOVA The scipy.stats submodule can be used to perform one-way analysis of variance (ANOVA). The method f_oneway is used to perform this test. The inputs are individual dataframes of all groups (in this discussion, groups are sectors). Click the block of code below and hit the Run button above. In [2]: import scipy . stats as st # save return data for individual sectors for input to f_oneway method. etf_returns_financial = etf_returns_df[ 'financial' ] etf_returns_energy = etf_returns_df [ 'energy' ] etf_returns_technology = etf_returns_df[ 'technology' ] # print the outputs: the test statistic and the P-value. test_statistic, p_value = st. f_oneway (etf_returns_financial, etf_returns_energy, etf_returns_technology) print ( "test statistic =", round(test_statistic, 2) ) print ( "P-value =", round(p_value, 4) ) test statistic = 55. 07 -value = 0.0Step 3: Visualizing differences There are post-hoc tests available that can be used to identify groups that are significantly different than others. Alternatively, a quick approach to identifying differences is to create a visual plot for data distributions using side-by-side boxplots. The block of code below uses the seaborn module and matplotlib.pyplot submodule to create side-by-side boxplots for the ten-year returns of ETFs in financial, energy, and technology sectors. Click the block of code below and hit the Run button above. NOTE: If the graph is not created, click the code section and hit the Run button again. In [4] : import matplotlib. pyplot as pit import seaborn as sns import numpy as np import random # side-by-side boxplots require the three dataframes to be concatenated and a require variable identifying the type of etf_returns_financial_df = etf_returns_df[ [ 'financial' ] ] etf_returns_financial_df = etf_returns_financial_df . rename (columns={"financial": "return"}) etf_returns_financial_df [ 'ETF'] = 'financial' etf_returns_energy_df = etf_returns_df [ ['energy' ] ] etf_returns_energy_df = etf_returns_energy_df . rename (columns={"energy": "return"} ) etf_returns_energy_df [ 'ETF' ] = 'energy etf_returns_technology_df = etf_returns_df [ [ ' technology' ] ] etf_returns_technology_df = etf_returns_technology_df . rename (columns={ "technology": "return"} ) etf_returns_technology_df [ 'ETF' ] = 'technology' # concatenate dataframes for the three ETFs. all_etfs_df = pd. concat ( (etf_returns_financial_df, etf_returns_energy_df, etf_returns_technology_df) ) # set a title for the plot, x-axis, and y-axis. pit . title( 'Boxplot for comparison', fontsize=20) # prepare the boxplot. sns . boxplot (x="ETF" ,y="return" , data=all_etfs_df) # show the plot. plt . show ( ) Boxplot for comparison 11 10 return inancial energy technology ETF

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Course In Number Theory

Authors: Mofidul Islam

1st Edition

9353147069, 9789353147068

More Books

Students also viewed these Mathematics questions

Question

Go, do not wait until I come

Answered: 1 week ago

Question

Make eye contact when talking and listening

Answered: 1 week ago

Question

Do not go, wait until I come

Answered: 1 week ago