Consider the following time series. Quarter Year 1 Year 2 Year 3 1 70 67 61 2 48 40 50 58 60 53 4 77 80 71 (a) Construct a time series plot. 90 90 90 90 80 80 80 80 70 70- 70 60 50 40 30 20 70 60 60 60 50 50 50 40 40 40 30 30 30 20 10- 20 10- 20 10 10- 123 4 1 2 3 4 1 2 3 4 123 4 1 2 3 4 1 2 3 4 12 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 Year 1 Year 2 Year 3 Year 1 Year 2 Year 3 Year 1 Year 2 Year 3 Year 1 Year 2 Year 3 Year/Quarter Year/Quarter Year/Quarter Year/Quarter What type of pattern exists in the data? O The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. O The time series plot shows a trend pattern with no seasonal pattern present. O The time series plot shows a horizontal pattern with no seasonal pattern present. O The time series plot shows a trend pattern, but there is also a seasonal pattern in the data. (b) Use the following dummy variables to develop an estimated regression equation to account for seasonal effects in the data: x, = 1 if quarter 1,0 otherwise; x, = 1 if quarter 2, o otherwise; x = 1 if quarter 3, 0 otherwise. (c) Compute the quarterly forecasts for next year.

Boran Stockbrokers, Inc., selects four stocks for the purpose of developing its own index of stock market behavior. Prices per share for a year 1 base period, January year 3, and March year 3 follow. Base-year quantities are set on the basis of historical volumes for the four stocks. Price per Share ($) Year 1 Stock Industry Quantity Year 1 March January Year 3 Base Year 3 A Oil 100 29.50 24.75 22.50 Computer 150 65.00 49.00 47.50 Steel 75 40.00 31.00 29.50 D Real Estate 50 18.00 6.50 3.75 Compute the price relatives for the four stocks making up the Boran index. (Round your answers to one decimal place.) Price Relative Stock January March A 2475.0 2250.0 B 7350.0 7125.0 2325.0 2212.5 D 325.0 187.5 Use the weighted average of price relatives to compute the January year 3 and March year 3 Boran indexes. (Round your answers to one decimal place.) IJan = 75.2 IMar = 70.9

I need some help with the following problems on excel.

Boran Stockbrokers, Inc., selects four stocks for the purpose of developing its own index of stock market behavior. Prices per share for a year 1 base period, January year 3, and March year 3 follow. Base-year quantities are set on the basis of historical volumes for the four stocks. Stock Industry Year 1Quantity Price per Share ($) Year 1Base JanuaryYear 3 MarchYear 3 A Oil 100 33.50 20.75 22.50 B Computer 150 65.00 49.00 47.50 C Steel 75 40.00 32.00 29.50 D Real Estate 50 18.00 6.50 4.75 Compute the price relatives for the four stocks making up the Boran index. (Round your answers to one decimal place.) Stock Price Relative     Stock January March   A ?? ?   B ? ?   C ? ?   D ? ?   Use the weighted average of price relatives to compute the January year 3 and March year 3 Boran indexes. (Round your answers to one decimal place.) IJan=?? IMar=??

Use Table 12-2 to calculate the present value (in $) of the ordinary annuity. (Round your answer to the nearest cent.) Nominal Annuity Payment Payment Frequency Time Interest Present Value Period (years) Rate (%) Compounded of the Annuity $4,000 every year 20 4 annually

QUESTION Samuel is a butchery vendor at a local open market. His daily income and the number of hours worked for the first ten days after the lockdown period is shown below: Day Income (N$) Number of hours  1 800 6 2 900 8 3 600 4 4 1200 5 5 1400 9 6 2000 9 7 1400 8 8 900 6 9 1300 7 10 1400 8   REQUIRED TO; determine whether it is the data time series or cross sectional? Motivate the reason. Calculate and interpret the following descriptive measures for the random variable Income:                                                                                 Mean Median Mode 33rd percentile Interquartile range  3. Calculate and interpret the covariance between the random variables Income and Number of hours worked.                                                                                            4. Calculate and interpret the correlation coefficient between the random…

Boran Stockbrokers, Inc., selects four stocks for the purpose of developing its own index of stock market behavior. Prices per share for a year 1 base period, January year 3, and March year 3 follow. Base-year quantities are set on the basis of historical volumes for the four stocks. Stock Industry Year 1Quantity Price per Share ($) Year 1Base JanuaryYear 3 MarchYear 3 A Oil 100 29.50 24.75 22.50 B Computer 150 65.00 49.00 47.50 C Steel 75 40.00 33.00 29.50 D Real Estate 50 18.00 6.50 3.75 -Compute the price relatives for the four stocks making up the Boran index. (Round your answers to one decimal place.) Stock Price Relative     January  March A     B     C     D       Use the weighted average of price relatives to compute the January year 3 and March year 3 Boran indexes. (Round your answers to one decimal place.)

the data set 1 2 3 5 7 7 8 9 10 12 13 13 14 14 15 16 16 19 19 21 23 23 23 24 26 26 27 27 28 28 31 32 34 35 35 36 36 37 40 43 44 45 46 46 46 52 52 53 54 55 55 55 57 57 58 59 59 60 63 63 65 66 70 71 71 74 77 77 78 80 80 80 81 82 82 Send data to Excel Part 1 of 4 ,th (a) Find the 77" percentile. th The 77" percentile is Part 2 of 4 (b) Find the 42nd percentile. The 42nd percentile is

An annual marathon covers a route that has a distance of approximately 26 miles. Winning times for this marathon are all over 2 hours. The following data are the minutes over 2 hours for the winning male runners over two periods of 20 years each. Earlier Period 10 8 14 20 16 17 21 21 18 1218 13 16 24 17 15 15 16 19 6 Recent Period 12 10 8 9 9 9 8 8 8 109 9 9 7 7 13 13 8 7 7 (a) Make a stem-and-leaf display for the minutes over 2 hours of the winning times for the earlier period. Use two lines per stem. (b) Make a stem-and-leaf display for the minutes over 2 hours of the winning times for the recent period. Use two lines per stem. (c) Compare the two distributions. How many times under 15 minutes are in each distribution?