The file P02_18.xlsx contains daily values of the S&P Index from 1970 to early 2012. It also
Question:
The file P02_18.xlsx contains daily values of the S&P Index from 1970 to early 2012. It also contains percentage changes in the index from each day to the next.
a. Create a new variable President that lists the U.S. presidents Nixon through Obama on each date. You can look up the presidents and dates online.
b. Use StatTools to find the mean, median, standard deviation, and first and third quartiles of % Change, broken down by President. Also, create side-by-side box plots of % Change, again broken down by President. Comment on the results.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (QA)
Standard Poors The SP 500 is an index of the market value of 500 largecap US firms across a range of industries Data One Var Summary StatTools Report Analysis One Variable Summary Performed By Chris D...View the full answer
Answered By
Ashington Waweru
I am a lecturer, research writer and also a qualified financial analyst and accountant. I am qualified and articulate in many disciplines including English, Accounting, Finance, Quantitative spreadsheet analysis, Economics, and Statistics. I am an expert with sixteen years of experience in online industry-related work. I have a master's in business administration and a bachelor’s degree in education, accounting, and economics options.
I am a writer and proofreading expert with sixteen years of experience in online writing, proofreading, and text editing. I have vast knowledge and experience in writing techniques and styles such as APA, ASA, MLA, Chicago, Turabian, IEEE, and many others.
I am also an online blogger and research writer with sixteen years of writing and proofreading articles and reports. I have written many scripts and articles for blogs, and I also specialize in search engine
I have sixteen years of experience in Excel data entry, Excel data analysis, R-studio quantitative analysis, SPSS quantitative analysis, research writing, and proofreading articles and reports. I will deliver the highest quality online and offline Excel, R, SPSS, and other spreadsheet solutions within your operational deadlines. I have also compiled many original Excel quantitative and text spreadsheets which solve client’s problems in my research writing career.
I have extensive enterprise resource planning accounting, financial modeling, financial reporting, and company analysis: customer relationship management, enterprise resource planning, financial accounting projects, and corporate finance.
I am articulate in psychology, engineering, nursing, counseling, project management, accounting, finance, quantitative spreadsheet analysis, statistical and economic analysis, among many other industry fields and academic disciplines. I work to solve problems and provide accurate and credible solutions and research reports in all industries in the global economy.
I have taught and conducted masters and Ph.D. thesis research for specialists in Quantitative finance, Financial Accounting, Actuarial science, Macroeconomics, Microeconomics, Risk Management, Managerial Economics, Engineering Economics, Financial economics, Taxation and many other disciplines including water engineering, psychology, e-commerce, mechanical engineering, leadership and many others.
I have developed many courses on online websites like Teachable and Thinkific. I also developed an accounting reporting automation software project for Utafiti sacco located at ILRI Uthiru Kenya when I was working there in year 2001.
I am a mature, self-motivated worker who delivers high-quality, on-time reports which solve client’s problems accurately.
I have written many academic and professional industry research papers and tutored many clients from college to university undergraduate, master's and Ph.D. students, and corporate professionals. I anticipate your hiring me.
I know I will deliver the highest quality work you will find anywhere to award me your project work. Please note that I am looking for a long-term work relationship with you. I look forward to you delivering the best service to you.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Business Analytics Data Analysis and Decision Making
ISBN: 978-1133629603
5th edition
Authors: S. Christian Albright, Wayne L. Winston
Question Posted:
Students also viewed these Business questions
-
A Logit regression is run on a sample of 5000 Canadians with "doc" as the dependent variable (doc=1 if the person went to see a doctor in the past month and doc=0 otherwise) and "injury" as one of...
-
answer questions 8 and 9 2(x - ax) dx O Year Gini Coefficient 1970 0.92 1.96 0.804 1980 0.899 1.94 0.388 1990 0.878 1.99 0.412 2000 0.848 2.01 0.437 2010 0.847 2.07 0.448 Question 8) ) Create a plot...
-
Problem 1 (5 points) Jupiter Company has provided the following comparative information: Net Income before income tax Income Tax Expense Interest Average total Assets Average total stockholders'...
-
Simplify the following expressions according to the commutative law: a. b. A B + A C + B A c. (L M N)(A B)(C D E)(M N L) d. F (K + R) + S V + W + V S + W + (R + K) F A.B + B.A + C.D.E + C.DE + E.T.D
-
Picture that great scene in Shakespeare's Richard III. King Richard, alone on the crest of a hill, his horse lost, his sword drawn, facing the oncoming enemy, shouts: "A horse, a horse, my kingdom...
-
Actividad 2: Llena blancos Utilizando la lista de trminos que se incluye, complete las siguientes oraciones. 1. A corporation has a separate __________________________ distinct from its owners. 2....
-
In your own words, define maturity date and bond indenture.
-
You are discussing your 401(k) with Dan Ervin when he mentions that Sarah Brown, a representative from Bledsoe Financial Services, is visiting East Coast Yachts today. You decide that you should meet...
-
Perpetual System-Calculating Ending Inventory and Cost of Sales Using Moving Average, FIFO, and LIFO April Inc. maintains a perpetual inventory system and recorded the following information for the...
-
The file P03_18.xlsx contains the times in the Chicago marathon for the top runners each year (the top 10,000 in 2006 and the top 20,000 in 2007 and 2008). a. Merge the data in these three sheets...
-
A supermarket transactions data set is likely to have hierarchical columns of data. For example, for the product sold, there might be columns like Product Family, Product Department, Product...
-
a Show correcting journal entries, if appropriate, for the following errors. Subsidiary ledgers are used. i Payment for motor vehicle $26 400 ($24 000 + $2400 GST) was processed to the office repairs...
-
Josie spends $60 at the end of each month on cigarettes. If shestops smoking and invests the same amount in an investment planpaying 6% compounded monthly, how much will she have after fiveyears? 2...
-
Say we have a Boeing 747 whose longitudinal flight dynamics for a given flight condition may be approximated using the following state equation (uncontrolled motion; thus no need to consider the...
-
a) Provide a brief background of the Honda Motor company and industry, then identify a current ethical issue that has an effect on the industry that the Honda Motor company is operating in. 1b)...
-
If you own, did you consider leasing? If yes, why did you choose a purchase over a lease? If you lease, why did you go with a lease? List the specific advantages you feel you gained by leasing. If...
-
If 5 people worked in a process for 8 hours, which included a 0.5 hour break, and they produced 900 units. What was the worker hours per unit? from below: 2.7 minutes 24 minutes 2.5 minutes 22.5...
-
Draw structures corresponding to the following IUPAC names: (a) 2-Methyl-1, 5-hexadiene (b) 3-Ethyl-2, 2-dimethyl-3-heptene (c) 2, 3, 3-Trimethyl-1, 4, 6-octatriene (d) 3, 4-Diisopropyl-2,...
-
A survey of 70 college freshmen asked whether students planned to take biology, chemistry, or physics during their first year. Use the diagram to answer each question. How many of the surveyed...
-
John Adams, Thomas Jefferson, and the Barbary Pirates: An Illustration of Relevant Costs for Decision Making Dennis Caplan, Assistant Professor Iowa State University. The concepts of incremental...
-
Quality Granite produces its product in two processing departments: Forming and Finishing. The followi five-step process costing procedure: (Click the icon to view the T-account.) 1. What is the...
-
Before purchasing a used car, Jim Myers checked www.kbb.com to learn what he should offer for the used car he wanted to buy. Then he conducted a carfax.com search on the car he found to see if the...
Study smarter with the SolutionInn App