Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

The information needed in on the excel pics. B G H Date 1/1 2/1 3/1 4/1 5/1 Open $45.14 $39.44 $41.02 $40.59 $39.57 $45.69 $52.43

image text in transcribed

image text in transcribed

image text in transcribed

The information needed in on the excel pics.

B G H Date 1/1 2/1 3/1 4/1 5/1 Open $45.14 $39.44 $41.02 $40.59 $39.57 $45.69 $52.43 $51.23 $53.19 $53.81 $50.33 $58.88 2018 Trends for Dell, Inc. High Low Close $51.16 $38.39 $39.70 $41.76 $35.97 $41.14 $44.21 $38.93 $40.54 $42.58 $39.16 $39.74 $45.92 $38.28 $44.66 $50.31 $45.69 $46.83 $53.24 $49.87 $51.23 $53.77 $51.16 $53.25 $54.83 $52.17 $53.78 $54.20 $47.48 $50.05 $59.37 $49.56 $58.41 $59.19 $41.58 $48.87 6/1 7/1 8/1 9/1 10/1 11/1 12/1 Adj Close Volume (000) Monthly Gain/Loss Volume Category $39.70 149015 Loss Minimal $41.14 76720 Gain Minimal $40.54 63528 Loss Minimal $39.74 40757 Loss Minimal $44.66 68256 Gain Minimal $46.83 58089 Gain Minimal $51.23 91460 Loss Minimal $53.25 50962 Gain Minimal $53.78 55404 Gain Minimal $50.05 75497 Loss Minimal $58.41 125937 Gain Minimal $48.87 138914 Loss Minimal Total Volume Months with Positive Trend Months with High Volume 994539230 6 1 Average $47.61 $50.88 $44.02 $47.35 $47.35 Range Category O Minimal 250,000,000 Low 500,000,000 Medium 750,000,000 High Date 1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019 6/1/2019 7/1/2019 8/1/2019 9/1/2019 10/1/2019 11/1/2019 12/1/2019 Open $48.23 $48.98 $57.68 $59.78 $67.90 $59.40 $52.21 $57.94 $51.03 $52.13 $53.18 $48.35 2019 Trends for Dell, Inc. High Low Close Adj Close $49.50 $42.02 $48.59 $48.59 $57.11 $48.50 $55.82 $55.82 $61.18 $51.58 $58.69 $58.69 $67.50 $59.22 $67.41 $67.41 $70.55 $57.11 $59.55 $59.55 $59.53 $50.57 $50.80 $50.80 $59.17 $50.60 $57.74 $57.74 $59.15 $44.35 $51.53 $51.53 $55.93 $50.27 $51.86 $51.86 $54.15 $48.75 $52.89 $52.89 $56.68 $48.44 $48.49 $48.49 $52.28 $46.43 $51.39 $51.39 Volume (000) Monthly Gain/Loss Volume Category 89170 Gain Minimal 43876 Gain Minimal 50981 Gain Minimal 32194 Gain Minimal 40724 Loss Minimal 52588 Loss Minimal 57977 Gain Minimal 78034 Loss Minimal 55026 Gain Minimal 34648 Gain Minimal 45660 Loss Minimal 50124 Gain Minimal Total Volume Months with Positive Trend Months with High Volume 631001200 Average $54.73 $58.56 $49.82 $54.56 $54.56 Question 1 What is the general price trend of your company over the current year? In the previous year? (Assign. 7) Question 2: What is the volume trend of your company in the current year? In the previous year? (Assign. 8) Question 3: How does your company's current year data compare to the previous year's data? (Assign. 5) B G H Date 1/1 2/1 3/1 4/1 5/1 Open $45.14 $39.44 $41.02 $40.59 $39.57 $45.69 $52.43 $51.23 $53.19 $53.81 $50.33 $58.88 2018 Trends for Dell, Inc. High Low Close $51.16 $38.39 $39.70 $41.76 $35.97 $41.14 $44.21 $38.93 $40.54 $42.58 $39.16 $39.74 $45.92 $38.28 $44.66 $50.31 $45.69 $46.83 $53.24 $49.87 $51.23 $53.77 $51.16 $53.25 $54.83 $52.17 $53.78 $54.20 $47.48 $50.05 $59.37 $49.56 $58.41 $59.19 $41.58 $48.87 6/1 7/1 8/1 9/1 10/1 11/1 12/1 Adj Close Volume (000) Monthly Gain/Loss Volume Category $39.70 149015 Loss Minimal $41.14 76720 Gain Minimal $40.54 63528 Loss Minimal $39.74 40757 Loss Minimal $44.66 68256 Gain Minimal $46.83 58089 Gain Minimal $51.23 91460 Loss Minimal $53.25 50962 Gain Minimal $53.78 55404 Gain Minimal $50.05 75497 Loss Minimal $58.41 125937 Gain Minimal $48.87 138914 Loss Minimal Total Volume Months with Positive Trend Months with High Volume 994539230 6 1 Average $47.61 $50.88 $44.02 $47.35 $47.35 Range Category O Minimal 250,000,000 Low 500,000,000 Medium 750,000,000 High Date 1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019 6/1/2019 7/1/2019 8/1/2019 9/1/2019 10/1/2019 11/1/2019 12/1/2019 Open $48.23 $48.98 $57.68 $59.78 $67.90 $59.40 $52.21 $57.94 $51.03 $52.13 $53.18 $48.35 2019 Trends for Dell, Inc. High Low Close Adj Close $49.50 $42.02 $48.59 $48.59 $57.11 $48.50 $55.82 $55.82 $61.18 $51.58 $58.69 $58.69 $67.50 $59.22 $67.41 $67.41 $70.55 $57.11 $59.55 $59.55 $59.53 $50.57 $50.80 $50.80 $59.17 $50.60 $57.74 $57.74 $59.15 $44.35 $51.53 $51.53 $55.93 $50.27 $51.86 $51.86 $54.15 $48.75 $52.89 $52.89 $56.68 $48.44 $48.49 $48.49 $52.28 $46.43 $51.39 $51.39 Volume (000) Monthly Gain/Loss Volume Category 89170 Gain Minimal 43876 Gain Minimal 50981 Gain Minimal 32194 Gain Minimal 40724 Loss Minimal 52588 Loss Minimal 57977 Gain Minimal 78034 Loss Minimal 55026 Gain Minimal 34648 Gain Minimal 45660 Loss Minimal 50124 Gain Minimal Total Volume Months with Positive Trend Months with High Volume 631001200 Average $54.73 $58.56 $49.82 $54.56 $54.56 Question 1 What is the general price trend of your company over the current year? In the previous year? (Assign. 7) Question 2: What is the volume trend of your company in the current year? In the previous year? (Assign. 8) Question 3: How does your company's current year data compare to the previous year's data? (Assign. 5)

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_2

Step: 3

blur-text-image_3

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

Frank Woods Business Accounting Volume 2

Authors: Frank Wood, Alan Sangster

10th Edition

0273693107, 978-0273693109

More Books

Students explore these related Accounting questions

Question

=+What about SRI funds? Why, or why not?

Answered: 3 weeks ago