BC MHSM 3303 Week 3 Application Assignment

.xlsx

School

Brazosport College *

*We aren’t endorsed by this school

Course

3303

Subject

Business

Date

Jan 9, 2024

Type

xlsx

Pages

20

Uploaded by marisolrios10

Report
Years S&P 500 Stock Price 2014 1,692 $68.00 2015 1,978 $102.00 2016 1,884 $110.00 2017 2,151 $112.00 2018 2,519 $154.00 COVARIANCE.S 9107.3 Now that you have determined the answer, it is time to provide a 1 or 2 sentence write up of your answer. In statistics, it is important that you not only get the correct mathematical answer, but that you become comfortable writing up your results in a manner that is easily understood by the reader/audience. Covariance formula is used to find the average poing of two different data sets. In this case it shows that in a 4 year range, the covarience is found to be 9107.3 between the stock and prices.
SAMPLE COVARIANCE Year Expenses 1 $56,000.00 2 $58,000.00 3 $70,678.00 4 $73,000.00 5 $77,000.00 6 $82,000.00 7 $78,000.00 8 $89,000.00 9 $90,000.00 10 $95,000.00 11 $100,000.00 12 $105,000.00 13 $102,000.00 14 $102,000.00 15 $112,222.00 16 $115,969.00 17 $119,716.00 COVARIANCE.S 95548.4375 Now that you have determined the answer, it is time to provide a 1 or 2 sentence write up of your answer. In statistics, it is important that you not only get the correct mathematical answer, but that you become comfortable writing up your results in a manner that is easily understood by the reader/audience. In 17 years there is a covarience of 95,548.44
CORREL Years S&P 500 Stock Price 2014 1,692 $68.00 2015 1,978 $102.00 2016 1,884 $110.00 2017 2,151 $112.00 2018 2,519 $154.00 CORREL 95% Now that you have determined the answer, it is time to provide a 1 or 2 sentence write up of your answer. In statistics, it is important that you not only get the correct mathematical answer, but that you become comfortable writing up your results in a manner that is easily understood by the reader/audience. I was able to examine the relationship between a stock price and the performance, which correlated it to 95%?? i dont know about this.
CORREL Year Expenses 1 $56,000.00 2 $58,000.00 3 $70,678.00 4 $73,000.00 5 $77,000.00 6 $82,000.00 7 $78,000.00 8 $89,000.00 9 $90,000.00 10 $95,000.00 11 $100,000.00 12 $105,000.00 13 $102,000.00 14 $102,000.00 15 $112,222.00 16 $115,969.00 17 $119,716.00 CORREL 0.98463909713939 Now that you have determined the answer, it is time to provide a 1 or 2 sentence write up of your answer. In statistics, it is important that you not only get the correct mathematical answer, but that you become comfortable writing up your results in a manner that is easily understood by the reader/audience. In a 17 year data set, it shows that expenses correlate to .98 in each year.
PEARSON Years S&P 500 Stock Price 2014 1,692 $68.00 2015 1,978 $102.00 2016 1,884 $110.00 2017 2,151 $112.00 2018 2,519 $154.00 PEARSON 0.94957382552453 Now that you have determined the answer, it is time to provide a 1 or 2 sentence write up of your answer. In statistics, it is important that you not only get the correct mathematical answer, but that you become comfortable writing up your results in a manner that is easily understood by the reader/audience. Pearson product moment correlation coefficient for the data sets above (0.94957 )
PEARSON Year Expenses 1 $56,000.00 2 $58,000.00 3 $70,678.00 4 $73,000.00 5 $77,000.00 6 $82,000.00 7 $78,000.00 8 $89,000.00 9 $90,000.00 10 $95,000.00 11 $100,000.00 12 $105,000.00 13 $102,000.00 14 $102,000.00 15 $112,222.00 16 $115,969.00 17 $119,716.00 PEARSON 0.98463909713939 Now that you have determined the answer, it is time to provide a 1 or 2 sentence write up of your answer. In statistics, it is important that you not only get the correct mathematical answer, but that you become comfortable writing up your results in a manner that is easily understood by the reader/audience. Using the data set above we can determine that the linear relationship between the two variable it 0.984639
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Recommended textbooks for you
Text book image
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Text book image
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Text book image
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
Text book image
Introduction to Business
Business
ISBN:9781947172548
Author:OpenStax
Publisher:OpenStax College
Text book image
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Text book image
Bcom
Business
ISBN:9780357026595
Author:LEHMAN, Carol M.
Publisher:Cengage Learning,
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Text book image
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Text book image
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
Text book image
Introduction to Business
Business
ISBN:9781947172548
Author:OpenStax
Publisher:OpenStax College
Text book image
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Text book image
Bcom
Business
ISBN:9780357026595
Author:LEHMAN, Carol M.
Publisher:Cengage Learning,
SEE MORE TEXTBOOKS