Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use Excel to answer the question The Closing Stock Prices data below provides data for four stocks and the Dow Jones Industrial Average over a

Use Excel to answer the question

The Closing Stock Prices data below provides data for four stocks and the Dow Jones Industrial Average over a one-month period.

1. Construct a visual of your choice to display all four stocks prices and the DJIA for each day over the period from 9/3/2010 to 10/1/2010. Be sure each stock/index is clearly identifiable.

Closing Stock Prices
Date IBM INTC CSCO GE DJ Industrials Index
9/3/10 $127.58 $18.43 $21.04 $15.39 10447.93
9/7/10 $125.95 $18.12 $20.58 $15.44 10340.69
9/8/10 $126.08 $17.90 $20.64 $15.70 10387.01
9/9/10 $126.36 $18.00 $20.61 $15.91 10415.24
9/10/10 $127.99 $17.97 $20.62 $15.98 10462.77
9/13/10 $129.61 $18.56 $21.26 $16.25 10544.13
9/14/10 $128.85 $18.74 $21.45 $16.16 10526.49
9/15/10 $129.43 $18.72 $21.59 $16.34 10572.73
9/16/10 $129.67 $18.97 $21.93 $16.23 10594.83
9/17/10 $130.19 $18.81 $21.86 $16.29 10607.85
9/20/10 $131.79 $18.93 $21.75 $16.55 10753.62
9/21/10 $131.98 $19.14 $21.64 $16.52 10761.03
9/22/10 $132.57 $19.01 $21.67 $16.50 10739.31
9/23/10 $131.67 $18.98 $21.53 $16.14 10662.42
9/24/10 $134.11 $19.42 $22.09 $16.66 10860.26
9/27/10 $134.65 $19.24 $22.11 $16.43 10812.04
9/28/10 $134.89 $19.51 $21.86 $16.44 10858.14
9/29/10 $135.48 $19.24 $21.87 $16.36 10835.28
9/30/10 $134.14 $19.20 $21.90 $16.25 10788.05
10/1/10 $135.64 $19.32 $21.91 $16.36 10829.68

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

Payroll Accounting

Authors: Bernard J. Bieg, Judith Toland

21st Edition

1111531056, 978-1111531058

More Books

Students also viewed these Accounting questions

Question

understand the limitations of classic models of job design.

Answered: 1 week ago