Question

In: Statistics and Probability

PotashCorp The data set in the file ch18_MCSP_PotashCorp contains average quarterly share prices for PotashCorp and...

PotashCorp

The data set in the file ch18_MCSP_PotashCorp contains average quarterly share prices for PotashCorp and prices for potash mineral. Investigate the relationship between these variables. (a) Some people think that if the share price of a mining company is high, that is because investors expect high mineral prices for thecorresponding quarter. Can the potash price be estimated from the PotashCorp share price? The data includes a period when the price of potash mineral was exceptionally high. If you eliminate the quarters when the price of potash was over CDN$600/tonne, does that affect your analysis? (b) Other people think that if the price at which a mineral can be sold is high, then the share price of the companies producing that mineral will also be high. Is that the case for PotashCorp? That is, can PotashCorp’s share price be estimated from the potashmineral price? If you eliminate the quarters when the price of potash was over CDN$600/tonne, does that affect your analysis? (c) Compare your answers to (a) and (b) including R-squared, P-value for slope, and the regression lines themselves.

Share Buy-Backs and Special Dividends in Canada

PotashCorp announced a program to buy back up to 5% of its common shares between August 2013 and July 2014.

When a company has a strong balance sheet with surplus cash, it needs to find a use for that cash consistent with its strategic goals and the current business environment. When economic conditions aren’t favourable for spending the cash to pay off debt, acquire another company or expand operations, it can use its cash in two other ways: (1) announcing a special dividend, and (2) buying back shares, otherwise known as stock repurchase agreements. Both of these options return value to shareholders. The difference between them is that share buy-backs can be done gradually over several quarters and the amount of the buy-back can be adjusted to the surplus cash available in future quarters; special dividends, on the other hand, require the company to be pretty certain that a base level of surplus cash will continue to be available in future quarters.

Suppose you’re advising the board of directors of a major company that needs to decide between a share buy-back and a special dividend. Surplus cash during the past eight quarters is given in the table. (Quarter 8 is the most recent.)

Quarter 1 2 3 4 5 6 7 8
Surplus Cash ($ billion) 1.2 0.8 1.4 1.3 0.9 1.4 1.3 1.1

The board will issue a special dividend if it can be both 95% certain that surplus cash will exceed $1.15 billion in quarter 9 and 95% certain that it will exceed $1.2 billion in quarter 10. It will announce a share buy-back program if it can be both 90% certain that the total surplus cash from quarter 9 will exceed $1.15 billion and that the surplus cash from quarter 10 will exceed $1.2 billion. Use linear regression to advise the board of directors about its options.

The data is given below

Year Quarter Potash mineral price (CDN$/tonne) PotashCorp share price (CDN$)
2008 1 490 45
2 510 65
3 665 58
4 955 33
2009 1 1070 27
2 845 33
3 605 31
4 475 35
2010 1 340 37
2 320 35
3 340 39
4 350 48
2011 1 360 57
2 400 56
3 430 53
4 480 46
2012 1 480 45
2 465 42
3 475 43
4 440 42
2013 1 405 41
2 400 41
3 400 34
4 375 31
2014 1 350 33
2 320 36
3 310 36
4 350 34
2015 1 385 35

Solutions

Expert Solution

Please find the solution below:

All the parts of the question are explained below...

A regression equation is calculated below based on the data provided:

Here,

Dependent Variable: Potash Mineral Price (Y)

Independent Variable: Share Price (X)

Plot of the Regression Equation:

Though there is a regression equation formed, but the model is not a good fit. Refer the Excel output below:

In the above output, refer the Refer the value of R squared. The value of R squared is not closer to 1. Generally, if the value of R squared is closer to 1, it means that maximum variation of the data is explained by the regression line in the model. But in this regard, as the value is very small, i.e. 0.036, it means that only 3.6% of the variations are explained be the regression line which doesn't signifies a good fit.

Thus it can be concluded that there is no such strong relationship between the Price of the Potash and its Share Price.

P Value Analysis:

For the intercept, the P value is very small and is less than 0.05. It means that there is a significant difference in it. This signifies that the null hypothesis is rejected and the alternate is accepted.

Here, the hypothesis are:

H0: β = 0

Ha: β is not equal 0

As a significant difference is obtained, so null hypothesis is not accepted and hence the intercept can't be 0.

But for the slope (Share Price), it can become 0 as the P value is more than 0.05 in this case. here, the null hypothesis is accepted.

End of the Solution...


Related Solutions

The data file "supermarket.csv" contains data on the total amount of eggs sold, relevant prices and...
The data file "supermarket.csv" contains data on the total amount of eggs sold, relevant prices and advertising information at a supermarket. 1) Treating the data as linear, run a multivariate regression of total egg sales on the three other variables. 2) Perform a log-log transformation of the data (Achieved by taking the natural logarithm of all variables except ad type). Run a multivariate regression of log total egg sales on log egg prices and log cookie prices (discard the dummy...
1.) The file cats.csv contains a data set consisting of the body weight (in kilograms) and...
1.) The file cats.csv contains a data set consisting of the body weight (in kilograms) and heart weight (in grams) for 12 cats. Give the estimated regression line using the body weight as the predictor variable (x-variable) and the heart weight as the response variable (y-variable). Also, provide interpretations in terms of the problem for the slope and the y-intercept. 2.) The file cats.csv contains a data set consisting of the body weight (in kilograms) and heart weight (in grams)...
1.) The file cats.csv contains a data set consisting of the body weight (in kilograms) and...
1.) The file cats.csv contains a data set consisting of the body weight (in kilograms) and heart weight (in grams) for 12 cats. Test at the 5% significance level that a positive linear relationship exists between the body weight of cat and their mean heart weight. Provides all parts of the test including hypotheses, test statistic, p-value, decision, and interpretation. 2.) The file cats.csv contains a data set consisting of the body weight (in kilograms) and heart weight (in grams)...
Consider the data in the file Growth.csvwhich contains data on average growth rates over 1960-1995 for...
Consider the data in the file Growth.csvwhich contains data on average growth rates over 1960-1995 for 65 countries, along with variables that are potentially related to growth. A complete description of the data is given in data description which is under the name Growth- Data Description and can be found on Blackboard. Using this data, carry out the following empirical exercises: Construct a table that shows the sample mean, std. deviation, minimum and maximum values for the variablesGrowth, Trade-Share, YearsSchool,...
The file Hotel Prices contains the prices in British pounds (about US$ 1.52 as of July...
The file Hotel Prices contains the prices in British pounds (about US$ 1.52 as of July 2013) of a room at two-star, three-star, and four-star hotels in cities around the world in 2013. City Two-Star Three-Star Four-Star Amsterdam 74 88 116 Bangkok 23 35 72 Barcelona 65 90 106 Beijing 35 50 79 Berlin 63 58 76 Boston 102 132 179 Brussels 66 85 98 Cancun 42 85 205 Chicago 66 115 142 Dubai 84 67 111 Dublin 48 66...
The file Hotel Prices contains the prices in British pounds (about US$ 1.52 as of July...
The file Hotel Prices contains the prices in British pounds (about US$ 1.52 as of July 2013) of a room at two-star, three-star, and four-star hotels in cities around the world in 2013. City Two-Star Three-Star Four-Star Amsterdam 74 88 116 Bangkok 23 35 72 Barcelona 65 90 106 Beijing 35 50 79 Berlin 63 58 76 Boston 102 132 179 Brussels 66 85 98 Cancun 42 85 205 Chicago 66 115 142 Dubai 84 67 111 Dublin 48 66...
If the file circuit.txt contains the following data
Exercise 2: If the file circuit.txt contains the following data 3.0             2.1 1.5             1.1 2.6             4.1 The first column is voltage and the second column is the electric current. Write program that reads the voltages and currents then calculates the electric power (P) based on the equation: Voltage     Current        Power 3.0             2.1              (result) 1.5             1.1              (result) 2.6             4.1              (result)                         P = v * i Write your output to the file results.txt with voltage in the first, current in the second...
The data file wages contains monthly values of the average hourly wages (in dol-lars) for workers...
The data file wages contains monthly values of the average hourly wages (in dol-lars) for workers in the U.S. apparel and textile products industry for July 1981 through June 1987. (a) Display and interpret the time series plot for these data. (b) Use least squares to fit a linear time trend to this time series. Interpret the regression output. Save the standardized residuals from the fit for further analysis. (c) Construct and interpret the time series plot of the standardized...
The data set for this question set (Tab Q1 in the Excel data file) comes from...
The data set for this question set (Tab Q1 in the Excel data file) comes from a research project that tracks the elderly residents in a community to monitor their cognitive function and general health. Based on the literature, education is considered a protective factor against dementia, and memory decline is usually the first sign of dementia. So the researchers would like to know whether education level (measured in number of years of formal schooling) is correlated with memory function...
Q1. The dataset jj.txt contains quarterly earnings per share for Johnson & Johnson. There are 84...
Q1. The dataset jj.txt contains quarterly earnings per share for Johnson & Johnson. There are 84 quarters (21 years) measured from the first quarter of 1960 to the last quarter of 1980. 1. Make a time plot of the Johnson & Johnson data by using R. Describe the data based on the graph. 2. Take a logarithm of the Johnson & Johnson data. Make a time plot of the log- transformed data and describe it. 3. Denote the Johnson &...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT