Question

In: Statistics and Probability

Instructions: You must use Excel or a similar statistical software package, such as SPSS, for your...

Instructions:

You must use Excel or a similar statistical software package, such as SPSS, for your assignment.

Tasks:

1.Select thirty stocks (at least 3 different industries) that are listed on the Toronto Stock Exchange.

2.Track each stock’s closing price at the end of the trading day. These closing prices will appear on the Internet. Collect the stock closing price data from January 2017 to December 2019.

4. For each stock, use your data to calculate and interpret: (show calculations)

a)the mean price

b)the median price

c) the standard deviation

d) the range

e) the interquartile range

f)the coefficient of variation

g) 90% confidence interval of mean price using t as the sampling distribution

Expert Solution

1.

Symbol	Value
BBD.B	2192926
ACB	3980134
AC	51648153
SU	50007633
MFC	39422375
TD	1.21E+08
ABX	53614527
CNQ	27623788
BTE	635699.4
ENB	76614244
CPG	1918041
CVE	4900995
XIU	32554663
K	9926848
IPL	13638751
BTO	6258014
PPL	39026541
WCP	1251906
AQN	18058138
TECK.B	11682180
TOG	630674.3
BIR	775210
FM	7769553
BNS	56614868
BPY.UN	11670734
RY	78418795
MEG	1370604
BCE	44793831
REI.UN	13576221
HSE	2900126

2.

Symbol	Close
BBD.B	0.48
ACB	1.06
AC	17.9
SU	19.11
MFC	16.7
TD	58.9
ABX	27.06
CNQ	14.23
BTE	0.355
ENB	40.52
CPG	1.03
CVE	2.84
XIU	20.09
K	6.63
IPL	10.13
BTO	5.16
PPL	31.34
WCP	1.17
AQN	17.03
TECK.B	10.97
TOG	0.62
BIR	0.74
FM	7.14
BNS	56.74
BPY.UN	12.57
RY	84.91
MEG	1.5
BCE	53.51
REI.UN	15.5
HSE	3.57

4.

mean	2,61,51,976.809167
median	1,26,29,200.120000
sample standard deviation	2,96,79,901.464332
minimum	630674.26
maximum	121083133.1
range	120452458.9
interquartile range	4,02,80,838.892500
coefficient of variation (CV)	113.49%
confidence interval 90.% lower	1,69,44,774.726309
confidence interval 90.% upper	3,53,59,178.892025
margin of error	92,07,202.082858
t(df = 29)	1.699

Please give me a thumbs-up if this helps you out. Thank you!

orchestra answered 1 year ago

Please describe the advantages and disadvantages of statistical package SAS, SPSS, R, and EXCEL (for A4...

Please describe the advantages and disadvantages of statistical package SAS, SPSS, R, and EXCEL (for A4 one page amount)

Use SPSS, Excel or Minitab software to answer the following questions. Generate normal random data with...

Use SPSS, Excel or Minitab software to answer the following questions. Generate normal random data with sample size, n = 40, mean = 20 and standard deviation = 11. Write the generated data in the following table. Answer: 1 11 21 31 2 12 22 32 3 13 23 33 4 14 24 34 5 15 25 35 6 16 26 36 7 17 27 37 8 18 28 38 9 19 29 39 10 20 30 40 Conduct the...

Write up how to use JMP for 5 items (or other statistical software) with instructions. Cite...

Write up how to use JMP for 5 items (or other statistical software) with instructions. Cite sources if needed. 1. How to import data and change data type (from nominal to interval/ratio level) 2. How to find descriptive statistics (mean, median, mode, variance, etc) 3. How to find confidence intervals 4. How to do linear regression 5. How to do ANOVA

Please use Statistical Software R Consider a dataset called fandango in fivethirtyeight package: Identify the Top...

Please use Statistical Software R Consider a dataset called fandango in fivethirtyeight package: Identify the Top 5 best rated and Top 5 worst rated movies based on rottentomatoes. Identify the Top 5 best rated and Top 5 worst rated movies based on the average of three users’ scores (rottentomatoes_user, metacritic_user, and imdb). Visualize the difference between Fandango stars and actual Fandango ratings. Comment on what you see. Construct a formal test to see if there is a significant difference between...

Instructions: **Must use formulas and link to cells throughout Excel file. Please name your project; i.e....

Instructions: **Must use formulas and link to cells throughout Excel file. Please name your project; i.e. Your Last Name_302 Project & Your Last Name_302 Memo. See Project Scoring Rubric for additional detail related to grading. A. Record the journal entries for the December transactions.**Must show formulas in cells. B. Record the adjusting journal entries for 12/31/18.**Must show formulas in cells. C. Set up a worksheet using Excel to: Prepare the Unadjusted Trial Balance as of December 31, by...

this is in excel VB8 Program 2: Software Sales A software company sells three packages, Package...

this is in excel VB8 Program 2: Software Sales A software company sells three packages, Package A, Package B, and Package C, which retail for $99, $199, and $299, respectively. Quantity discounts are given according to the following table: Quantity Discount 10 through 19 20% 20 through 49 30% 50 through 99 40% 100 or more 50% Create an application that allows the user to enter the number of units sold for each software package. The application should calculate and...

This assignment is designed to illustrate how a software package such as Microsoft Excel supplemented by...

This assignment is designed to illustrate how a software package such as Microsoft Excel supplemented by an add-in such as PHStat can enable one to make decisions about the behavior of a single population parameter. You must provide printouts of all results of the hypothesis tests that you accomplish as you fulfill the requirements of this assignment. You should not only find the required information to make the appropriate decisions, but you also should provide explanations, in the context of...

SPSS: Correlation Use SPSS or Excel to calculate the appropriate correlation coefficient for the following data...

SPSS: Correlation Use SPSS or Excel to calculate the appropriate correlation coefficient for the following data for “Hours of Exercise” and “Life Satisfaction.” (0 = Not at all satisfied). Provide an APA-style results section write – up. (b) Graph the relationship. HINT: Below you will find instructions for the APA-style write-up. Complete the write-up on a word document and upload the file for submission. Hours of Exercise. 2 0 5 6 1 2 4 4 3 4 life satisfaction...

Different types of software can be used for data managment. Excel and SPSS and discuss specific...

Different types of software can be used for data managment. Excel and SPSS and discuss specific SPSS software features that make it preferable to Excel for data managment. provide examples illustrating when electing to use the SPSS could be preferable to Excel and vice versa

Different types of software can be used for data management. Compare Excel and SPSS and discuss...

Different types of software can be used for data management. Compare Excel and SPSS and discuss specific SPSS software features that make it preferable to Excel for data management. Provide examples illustrating when electing to use SPSS could be preferable to Excel and vice versa.