Answered step by step
Verified Expert Solution
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
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
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