Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a Word document and analyze data using at least two sentences per question to describe what your data shows. Use results collected in Excel
Create a Word document and analyze data using at least two sentences per question to describe what your data shows. Use results collected in Excel Exercises 7, 8, and 5, as described in the video. Answer the three questions by analyzing the data. Are the items trending up or down? Are the prices flat or increasing? Compare and contrast current v. previous year current year = 2021 data previous year = 2020 data
1 ~34 2 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 A Date 1/1 2/1 3/1 4/1 5/1 6/1 7/1 8/1 9/1 10/1 11/1 12/1 Average B Open E 2021 Trends For JP Morgan Chase & Co. High Close $127.50 $129.40 $149.52 $151.90 $154.85 $165.87 $156.26 $152.03 $160.22 $164.00 $172.04 $161.00 $153.72 $142.75 $154.90 $161.69 $157.25 Ready Accessibility: Investigate $165.70 $167.44 $159.16 $163.83 $169.30 $172.96 $172.33 $163.39 $162.56 JP Morgan Chase & Co. Low $123.77 $128.48 $147.97 $146.69 $152.14 $147.56 $145.71 $149.52 $150.49 $160.06 $158.29 $151.84 $146.88 LL $164.24 $155.54 $151.78 $159.95 $163.69 $169.89 $158.83 $158.35 $128.67 $147.17 $141.43 $152.23 $146.29 $153.81 $147.81 $158.76 $150.35 Adj Close Volume (000) $122.77 $146.72 $155.51 $159.14 $165.17 $155.35 $154.88 G $155.35 $150.35 318582 Gain 229245 Gain 399417 Gain 288694 Gain 248958 Gain 356723 Loss 280572 Loss 208086 Gain 234791 Gain 231681 Gain 203498 Loss 251966 Loss A Total Volume Months with Positive Tre 3252213700 Monthly Gain/Loss Range 228| H 4x 250,00 500,00 + 100% 9:51 PM 11/3/2022
Step by Step Solution
★★★★★
3.45 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
Based on the provided data for JP Morgan Chase Co for the years 2020 and 2021 1 Trends Analysis Volu...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started