1)
a) Construct a 95% confidence interval about the mean response at x = 46 using the data set Steam.
b) Calculate the R2 value and the coefficient of correlation for the data set Steam.
Steam Data Set





1) a) Construct a 95% confidence interval about the mean response at x = 46 using...
II) (10 marks) The number of pounds of steam used per month by a chemical plant is thought to be related to the average ambient temperature (in F) for that month. An investigator has collected the past year's usage and temperature in a table. Some summary statistics related to this dataset are provided y-5062.212x,2-29256, n 12 , x,-558, y,2 2416144 Xiy.-265864.6, (yi-%)2-37.746 Month Temp. Usage/1000 Jan 21 Feb 24 Mar. 32 Apr. 47 May 50 June 59 July 68 Aug....
Please use python codes thank you so much!!! I really need help!!! Create a plot showing the monthly average temperature starting in January 2001 (one plot showing all data points from January 2001 through December 2003). Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2001 42 43 55 50 56 54 60 48 53 50 69 55 2002 75 75 89 56 63 55 61 53 62 55 58 43 2003 73 55 57 53...
calculate the monthly time-weighted and money weighted returns for shareholders in the ADKSX with using excel. In a text box nearby, comment on whether investors’ trading decisions have created value. Month ADKSX Return (%) ADKSX Cash Flow ($) Nov-09 3.49 -$10,648,393 Dec-09 6.93 -$618,800 Jan-10 -2.05 $940,820 Feb-10 5.74 -$2,484,437 Mar-10 5.19 -$3,699,836 Apr-10 5.48 -$1,379,757 May-10 -4.68 $2,145,936 Jun-10 -6.31 -$2,953,884 Jul-10 5.9 -$4,160,472 Aug-10 -5.18 $1,096,304 Sep-10 8.61 -$5,571,657 Oct-10 4.5 -$669,464 Nov-10 2.77 -$3,145,367 Dec-10 9.16 -$6,162,018...
Calculate the sample correlation coefficient rxy. Calculate the value of the test statistic. Date Energy Healthcare Jan-10 -4.87 -0.15 Feb-10 1.8 0.53 Mar-10 2.26 1.41 Apr-10 3.03 -3.75 May-10 -11.5 -5.12 Jun-10 -5.67 -0.52 Jul-10 8.73 1.49 Aug-10 -5.99 -0.97 Sep-10 10.15 8.24 Oct-10 3.89 2.28 Nov-10 2.85 -2.52 Dec-10 5.55 1.4 Jan-11 6.6 1.55 Feb-11 5.7 3.04 Mar-11 1.32 1.22 Apr-11 1.64 5.89 May-11 -4.06 2.62 Jun-11 -2.08 -0.55 Jul-11 1.14 -2.64 Aug-11 -10.41 -2.8 Sep-11 -15.06 -4.17 Oct-11...
From the following monthly stock prices assume rf of 0.5% per
month and calculate
1.Monthly growth return
2.CAPM and beta
3.Average return
4.Variance
5.Covariance
6. Assume a credit rating and calculate a VAT assuming debt to
equity structure
1 date share price benchmark 2 Mar 18 3 Feb-18 4 Jan-18 5 Dec-17 6 Nov-17 7 Oct-17 8 Sep-17 304.85 24,263.35 322.3 25,107.40 354.4 27,379.45 315.15 25,539.45 306.9 25,332.40 314.25 25,019.35 350 24.053.00 350.61 24,318.40 361.9 25,103.65 292.7 23,211.20 286.27 23,424.80...
Trends Which trend line do you think best fits the following data? Plot your chosen trend line and explain why you chose that particular type of trend line. Month Sales Month Sales Month Sales Oct-12 12.50 Oct-13 33.53 Oct-14 43.31 Nov-12 19.78 Nov-13 32.88 Nov-14 44.17 Dec-12 14.58 Dec-13 45.59 Dec-14 59.66 Jan-13 19.85 Jan-14 35.85 Jan-15 56.00 Feb-13 14.15 Feb-14 22.49 Feb-15 54.95 Mar-13 8.82 Mar-14 38.94 Mar-15 40.78 Apr-13 (3.52) Apr-14 19.90 Apr-15 42.10 May-13 10.96 May-14 16.65...
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...
Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 Dec-13 6 Mar-14 un-14 Jul-14 14 ep-14 ct-14 4.67 9.05 8.57 Feb-15 5.02 4.8 Apr-15 0.58 7.79 Aug-15 4.83 5.81 Dec-15 11.81 1.5 8.84 1.8 12.42 Apr-16 May-16 2.62 2.75 0.04 5.2 4.95 0.59 7.67 Jul-16 Aug-16 Dec-16 0.2 5.23 The following table shows a portion of the monthly returns data (in percent) for 2010-2016 for two of Vanguard's mutual funds: the Vanguard Energy Fund and the...
The human resources department needs to forecast the number of employees at a site. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is the 7 month moving average. Please round your forecast to the nearest whole number Nov 2019: 956 Oct 2019: 1014 Sep 2019: 1009 Aug 2019: 963 Jul 2019: 966 Jun 2019: 1024 May 2019: 1045||Apr 2019: 1047 Mar...
Consider five years of monthly sales data for a company in the
attached file (Q5.xlsx). a) Forecast monthly sales for the next
year (2020). (10 marks) b) Discuss whether a simple exponential
smoothing model works well with this data or not. (5 m
7 9 Month Sales 747 Feb-14 697 Mar-14 1014 Jan-14 Ap4 1126 May-14 1105 Jun-14 1450 Jul-14 1633 Aug-14 1711 Sep-14 1307 Oct-1223 Nov-14 9T5 Dec-14S53 4J-15 1024 Feb-15928 Mar-151442 7Apr-151371 May-15 1536 Ju15 2004 Jul-15 1854...