6. Jordan_10e_EOCExcelSolutions_Chapter08

xls

School

University of Toronto *

*We aren’t endorsed by this school

Course

441

Subject

Industrial Engineering

Date

Oct 30, 2023

Type

xls

Pages

37

Uploaded by GrandBookBat32

Report
Chapter 8 Problems 1-15 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To install these, click on "Tools|Add-Ins" and select "Analysis ToolPak" and "Solver Add-In."
"
Chapter 8 Question 1 Input Area: Advancing Advancing Vol. Declining Monday 1,634 825,503 1,402 Tuesday 1,876 928,360 1,171 Wednesday 1,640 623,369 1,410 Thursday 2,495 1,101,332 537 Friday 1,532 508,790 1,459 Output Area: Adv.-Dec. Cumulative Monday 232 232 Tuesday 705 937 Wednesday 230 1,167 Thursday 1,958 3,125 Friday 73 3,198
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Declining Vol. 684,997 440,665 719,592 173,003 498,585
Chapter 8 Question 2 Input Area: Advancing Advancing Vol. Declining Monday 1,634 825,503 1,402 Tuesday 1,876 928,360 1,171 Wednesday 1,640 623,369 1,410 Thursday 2,495 1,101,332 537 Friday 1,532 508,790 1,459 Output Area: Avg. Dec. Vol. Avg. Adv. Vol. Arms Ratio Monday 488.586 505.204 0.967 Tuesday 376.315 494.861 0.760 Wednesday 510.349 380.103 1.343 Thursday 322.166 441.416 0.730 Friday 341.731 332.108 1.029
Declining Vol. 684,997 440,665 719,592 173,003 498,585
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 3 Input Area: Penn Teller January $ 169.64 $ 600.36 February $ 173.29 $ 613.40 March $ 180.13 $ 586.76 April $ 195.81 $ 544.10 May $ 196.69 $ 529.02 June $ 204.49 $ 506.38 July $ 222.52 $ 603.69 August $ 215.23 $ 540.96 September $ 216.23 $ 515.04 October $ 213.51 $ 592.64 November $ 192.29 $ 599.39 December $ 173.10 $ 645.90 Output Area: The moving averages must be calculated relative to the share price; also note that results can't be computed for the first two months because of insufficient data. Penn Teller January $ - $ - February $ - $ - March $ 174.35 $ 600.17 April $ 183.08 $ 581.42 May $ 190.88 $ 553.29 June $ 199.00 $ 526.50 July $ 207.90 $ 546.36 August $ 214.08 $ 550.34 September $ 217.99 $ 553.23 October $ 214.99 $ 549.55 November $ 207.34 $ 569.02 December $ 192.97 $ 612.64
Chapter 8 Question 4 Input Area: Penn Teller January $ 169.64 $ 600.36 February $ 173.29 $ 613.40 March $ 180.13 $ 586.76 April $ 195.81 $ 544.10 May $ 196.69 $ 529.02 June $ 204.49 $ 506.38 July $ 222.52 $ 603.69 August $ 215.23 $ 540.96 September $ 216.23 $ 515.04 October $ 213.51 $ 592.64 November $ 192.29 $ 599.39 December $ 173.10 $ 645.90 Weight for most recent month 2/3 Output Area: The moving averages must be calculated relative to the share price; also note that results can't be computed for the first two months because of insufficient data. Penn Teller January $ - $ - February $ - $ - March $ 177.24 $ 593.47 April $ 189.62 $ 560.56 May $ 194.33 $ 539.53 June $ 201.10 $ 517.43 July $ 215.38 $ 574.94 August $ 215.28 $ 552.29 September $ 215.91 $ 527.46 October $ 214.31 $ 570.91 November $ 199.63 $ 589.90
December $ 181.94 $ 627.23
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 5 Input Area: Penn Teller January $ 169.64 $ 600.36 February $ 173.29 $ 613.40 March $ 180.13 $ 586.76 April $ 195.81 $ 544.10 May $ 196.69 $ 529.02 June $ 204.49 $ 506.38 July $ 222.52 $ 603.69 August $ 215.23 $ 540.96 September $ 216.23 $ 515.04 October $ 213.51 $ 592.64 November $ 192.29 $ 599.39 December $ 173.10 $ 645.90 Weight for most recent month 50% Output Area: The moving averages must be calculated relative to the share price; also note that results can't be computed for the first two months because of insufficient data. Penn Teller January $ - $ - February $ - $ - March $ 175.80 $ 596.82 April $ 185.80 $ 570.46 May $ 191.25 $ 549.74 June $ 197.87 $ 528.06 July $ 210.19 $ 565.88 August $ 212.71 $ 553.42 September $ 214.47 $ 534.23 October $ 213.99 $ 563.43 November $ 203.14 $ 581.41
December $ 188.12 $ 613.66
Chapter 8 Question 6 Input Area: Week Bulls Bears 1 58 63 2 53 68 3 47 74 4 50 71 5 43 78 Output Area: Week MSI 1 0.5207 2 0.5620 3 0.6116 4 0.5868 5 0.6446
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 7 Input Area: Price Volume $ 70.12 $ 70.14 1,900 $ 70.13 1,400 $ 70.09 1,800 $ 70.05 2,100 $ 70.07 2,700 $ 70.03 3,000 Output Area: Price Up/Down $ 70.12 $ 70.14 + $ 133,266.00 $ 133,266.00 $ 70.13 - $ 98,182.00 $ - $ 70.09 - $ 126,162.00 $ - $ 70.05 - $ 147,105.00 $ - $ 70.07 + $ 189,189.00 $ 322,455.00 $ 70.03 - $ 210,090.00 $ - Money flow at the e Price times Volume Positive Money Flow
Net Money Flow $ - $ 98,182.00 $ 224,344.00 $ 371,449.00 $ - $ 581,539.00 end of the day $ (259,084.00) Negative Money Flow
Chapter 8 Question 8 Input Area: Date Close 4/1/2022 2867.19 4/2/2022 2867.24 4/3/2022 2873.40 4/4/2022 2879.39 4/5/2022 2892.74 4/8/2022 2895.77 4/9/2022 2878.20 4/10/2022 2888.21 4/11/2022 2888.32 4/12/2022 2907.41 Weight for most recent close 2/3 Output Area: Date Simple Exponential 4/1/2022 - - 4/2/2022 - 2,867.21 4/3/2022 2,869.28 2,871.34 4/4/2022 2,873.34 2,876.71 4/5/2022 2,881.84 2,887.40 4/8/2022 2,889.30 2,892.98 4/9/2022 2,888.90 2,883.13 4/10/2022 2,887.39 2,886.52 4/11/2022 2,884.91 2,887.72 4/12/2022 2,894.65 2,900.85 The reason to calculate the moving average on an index is the same for an individual stock. It can give an indication of whether the market as a whole is moving upward or downward compared to its recent past. If the index closed below the 3-day moving average, it would be a sell indicator.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 9 Output Area: There appears to be a support level at about $25. The resistance level may be about $30, although the stock did break through for a period. So, it may have short-term resistance at $30 and longer-term resistance at $34. A support level is a level below which the stock or market is unlikely to go. A resistance level is a level above which the stock or market is likely to rise.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 10 Input Area: Advancing Advancing Vol. Declining Monday 2,530 995,111 519 Tuesday 2,429 934,531 639 Wednesday 1,579 517,007 1,407 Thursday 2,198 925,424 823 Friday 1,829 592,335 1,188 Output Area: Adv.-Dec. Cumulative Monday 2,011 2,011 Tuesday 1,790 3,801 Wednesday 172 3,973 Thursday 1,375 5,348 Friday 641 5,989 Avg. Dec. Vol. Avg. Adv. Vol. Arms Ratio Monday 214.264 393.325 0.545 Tuesday 321.701 384.739 0.836 Wednesday 354.011 327.427 1.081 Thursday 380.431 421.030 0.904 Friday 323.298 323.857 0.998
Declining Vol. 111,203 205,567 498,094 313,095 384,078
Chapter 8 Question 11 Input Area: Price Volume $ 61.85 $ 61.81 1,000 $ 61.82 1,400 $ 61.85 1,300 $ 61.84 800 $ 61.87 1,100 $ 61.88 1,400 $ 61.92 600 $ 61.91 1,200 $ 61.93 1,600 Output Area: Price Up/Down $ 61.85 $ 61.81 - $ 61,810.00 $ - $ 61.82 + $ 86,548.00 $ 86,548.00 $ 61.85 + $ 80,405.00 $ 166,953.00 $ 61.84 - $ 49,472.00 $ - $ 61.87 + $ 68,057.00 $ 235,010.00 $ 61.88 + $ 86,632.00 $ 321,642.00 $ 61.92 + $ 37,152.00 $ 358,794.00 $ 61.91 - $ 74,292.00 $ - $ 61.93 + $ 99,088.00 $ 457,882.00 Money flow at the e Price times Volume Positive Money Flow
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Net Money Flow $ 61,810.00 $ - $ - $ 111,282.00 $ - $ - $ - $ 185,574.00 $ - end of the day $ 272,308.00 Negative Money Flow
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 12 Input Area: Low price $ 32.00 High price $ 45.00 Output Area: Phi 1.6180 Primary support $ 40.03 Secondary support $ 36.97
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 13 Input Area: Date Close 1 $39.65 2 39.30 3 39.86 4 41.05 5 41.23 6 41.02 7 40.75 8 41.16 9 40.38 10 39.44 11 40.07 12 40.19 13 40.56 14 41.21 15 40.74 Output Area: Day 3-day 5-day 1 $ - $ - 2 $ - $ - 3 $ 39.60 $ - 4 $ 40.07 $ - 5 $ 40.71 $ 40.22 6 $ 41.10 $ 40.49 7 $ 41.00 $ 40.78 8 $ 40.98 $ 41.04 9 $ 40.76 $ 40.91 10 $ 40.33 $ 40.55 11 $ 39.96 $ 40.36 12 $ 39.90 $ 40.25 13 $ 40.27 $ 40.13 14 $ 40.65 $ 40.29
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
15 $ 40.84 $ 40.55 4 6 8 10 12 14 16 $39.20 $39.40 $39.60 $39.80 $40.00 $40.20 $40.40 $40.60 $40.80 $41.00 $41.20 Column D Column F
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 14 Input Area: Date Close 1 $ 39.65 2 $ 39.30 3 $ 39.86 4 $ 41.05 5 $ 41.23 6 $ 41.02 7 $ 40.75 8 $ 41.16 9 $ 40.38 10 $ 39.44 11 $ 40.07 12 $ 40.19 13 $ 40.56 14 $ 41.21 15 $ 40.74 Weight 2/3 Output Area: Date 3-day 5-day 1 $ - $ - 2 $ - $ - 3 $ 39.73 $ - 4 $ 40.61 $ - 5 $ 41.02 $ 40.81 6 $ 41.02 $ 40.95 7 $ 40.84 $ 40.82 8 $ 41.05 $ 41.05 9 $ 40.60 $ 40.60 10 $ 39.83 $ 39.83 11 $ 39.99 $ 39.99 12 $ 40.12 $ 40.12
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
13 $ 40.41 $ 40.41 14 $ 40.94 $ 40.94 15 $ 40.81 $ 40.81 4 6 8 10 12 14 16 $39.20 $39.40 $39.60 $39.80 $40.00 $40.20 $40.40 $40.60 $40.80 $41.00 $41.20 Column D Column F
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 15 Input Area: Week Puts Calls 1 1,874,986 1,631,846 2 1,991,650 1,772,815 3 2,187,450 1,976,277 4 2,392,751 2,182,270 Output Area: Week Put/Call Ratio 1 1.1490 2 1.1234 3 1.1069 4 1.0965 The put/call ratio is a measure of investor sentiment about the future direction of the market. Puts are a bet that the market (or stock) will move down and calls are a bet the market (or stock) will move upwards. The put/call ratio is the number of down bets divided by the number of up bets. A ratio greater than one indicates more investors believe the market (or stock) will move down than the number of investors who believe the market will move up. It is a bearish signal. From these numbers, it appears more investors believe the market will move down in the future.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 16 Input Area: Date Adj. Close 1/24/2022 34,070.61 1/25/2022 34,186.64 1/26/2022 34,520.82 1/27/2022 34,261.75 1/28/2022 34,135.24 1/31/2022 34,691.17 2/1/2022 35,151.47 2/2/2022 35,378.19 2/3/2022 35,520.08 2/4/2022 35,095.74 2/7/2022 35,108.38 2/8/2022 35,160.68 2/9/2022 35,614.90 2/10/2022 35,630.81 2/11/2022 35,267.89 Weight of most recent closing price: 0.8 Output Area: 3-day Simple Buy/Sell 3-day Exponential Date Adj Close Moving Average Signal Moving Average 1/24/2022 34,070.61 1/25/2022 34,186.64 34,128.63 1/26/2022 34,520.82 34,259.36 BUY 34,442.38 1/27/2022 34,261.75 34,323.07 SELL 34,297.88 1/28/2022 34,135.24 34,305.94 SELL 34,167.77 1/31/2022 34,691.17 34,362.72 BUY 34,586.49 2/1/2022 35,151.47 34,659.29 BUY 35,038.47 2/2/2022 35,378.19 35,073.61 BUY 35,310.25 2/3/2022 35,520.08 35,349.91 BUY 35,478.11 2/4/2022 35,095.74 35,331.34 SELL 35,172.21 2/7/2022 35,108.38 35,241.40 SELL 35,121.15 2/8/2022 35,160.68 35,121.60 BUY 35,152.77 2/9/2022 35,614.90 35,294.65 BUY 35,522.47 2/10/2022 35,630.81 35,468.80 BUY 35,609.14
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2/11/2022 35,267.89 35,504.53 SELL 35,336.14
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Buy/Sell Signal Signal Comparison BUY AGREE SELL AGREE SELL AGREE BUY AGREE BUY AGREE BUY AGREE BUY AGREE SELL AGREE SELL AGREE BUY AGREE BUY AGREE BUY AGREE
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
SELL AGREE
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Chapter 8 Question 17 Input Area: 20-Day Simple Standard Deviation Date AAPL Close Moving Average of 20-Day MA 3/26/2019 186.79 180.88 3.40 3/27/2019 188.47 181.50 3.60 3/28/2019 188.72 182.18 3.80 3/29/2019 189.95 182.96 4.00 4/1/2019 191.24 183.71 4.20 4/2/2019 194.02 184.48 4.39 4/3/2019 195.35 185.40 4.57 4/4/2019 195.69 186.45 4.72 4/5/2019 197.00 187.61 4.86 4/8/2019 200.10 188.81 4.99 4/9/2019 199.50 189.87 5.10 4/10/2019 200.62 190.80 5.19 4/11/2019 198.95 191.74 5.25 4/12/2019 198.87 192.51 5.27 Output Area: Lower 20-Day Simple Standard Deviation Bollinger Date AAPL Close Moving Average of 20-Day MA Band 3/26/2019 186.79 180.88 3.40 174.08 3/27/2019 188.47 181.50 3.60 174.30 3/28/2019 188.72 182.18 3.80 174.58 3/29/2019 189.95 182.96 4.00 174.96 4/1/2019 191.24 183.71 4.20 175.31 4/2/2019 194.02 184.48 4.39 175.70 4/3/2019 195.35 185.40 4.57 176.26 4/4/2019 195.69 186.45 4.72 177.01 4/5/2019 197.00 187.61 4.86 177.89 4/8/2019 200.10 188.81 4.99 178.83 4/9/2019 199.50 189.87 5.10 179.67 4/10/2019 200.62 190.80 5.19 180.42 4/11/2019 198.95 191.74 5.25 181.24 4/12/2019 198.87 192.51 5.27 181.97
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
43550 43551 43552 43553 43554 43555 43556 43557 43558 43559 43560 43561 43562 43563 43564 43565 43566 43567 165 175 185 195 205 Bollinger Bands 20-Day MA Upper B-Band Lower B-Band AAPL
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Upper Bollinger Band 187.68 188.70 189.78 190.96 192.11 193.26 194.54 195.89 197.33 198.79 200.07 201.18 202.24 203.05
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
567
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

Bio Lab Graphing Homework 2.docx
Gannon Molumby - Stream Cross Section Data.xlsx
1301-CH 17 Assignment.docx
EC120OC - MIDTERM INFO FALL 2023 UPDATED WITH RM NUMBER (1).doc
Week 6 Summary Review Questions.docx
EM365_7-2_MidtermReview.pdf
SNHU 107 Module Four Journal Template Tyrisha (1).docx
SNHU 107 Project Template.docx
ElectrostaticsI&II.pdf
MusicAndItsContextSyllabus.pdf
Lecture 22.pdf
Amira Hill - Health History .pdf

Browse Popular Homework Q&A

Q: Computer for the following data and test the hypothesis Ho: p=0. Draw the scatter plot; then explain…
Q: Ch. 6: The laboratory sends you these ABG results for your patient: pH 7.32, PaCO2 40 mmHg, and…
Q: Convert a drip rate of 0.07259 mL/min to L/day. Report just your numerical answer to the correct…
Q: Explain the meaning of the accompanying percentiles. ​(a) The 5th percentile of the head…
Q: a news article depicting a dilemma in helping profession
Q: At one point the average price of regular unleaded gasoline was ​$3.75 per gallon. Assume that the…
Q: 2, and v3 be corresponding eigenvectors, respectively. B = {V₁, V2, V3} is a linearly independent…
Q: Determine whether the Mean Value theorem can be applied to f on the closed interval [a, b].
Q: Determine whether the Mean Value theorem can be applied to f on the closed interval [a, b].
Q: 1. Consider this compound ("your compound"): CH₂0 (11 I I'
Q: When reducing [A | I], a row in the A part consists of all zeros. What does this indicate about A-¹?…
Q: Besides blood and urine, what are other body fluids that can be collected for diagnostic purposes?…
Q: Annual high temperatures in a certain location have been tracked for several years. Let X represent…
Q: 2. Let X; (i=1, 2, 3) equal the distance (in yards) that a golf ball travels when hit from a tee,…
Q: A circular segment has Radius r = 1.00m and tore arclength that is defined by total what is value of…
Q: The average score of all golfers for a particular course has a mean of 64 and a standard deviation…
Q: A string that is 3.6 m long is tied between two posts and plucked. The string produces a wave that…
Q: Convert 100mg/L to mol/L
Q: Criven: 73.4N E כח 73.4 № A 35° X 73.4 N diameter 0.400 m => Find the distance from the origin the…
Q: If the total momentum of a system is changing: O A net external force must be acting on the system.…
Q: Co D N B F 500 mm E A 250 mm 300 mm
Q: Sketch the region that corresponds to the given inequality. 4x - y ≤ 6 -15 -15 -10 -5 y 15 Solution…
Q: The revenue function for a sound system is R(x) = 400x − x2 dollars where x denotes the number of…
Q: 12. Which curve listed below describes the velocity of a simple harmonic oscillator (as a function…
Q: Determine the force in the spring with stretched length 3 inches and a spring potent of 2.10 Jhift…