Great Problem to check your Stock skills..Pls. provide the solution asap

#1
Question: Find the percentage of returns of BSE 30 which are because of the movement in Oil prices.

Data available is Value of the BSE 30 at the closing time on different dates and Oil prices in US$ as follows:

Date SENSEX(BSE30) Oil Prices ($)
14-Aug-07 15000.91 ------ 71.47000
13-Aug-07 15017.21 ------ 71.47
10-Aug-07 14868.25 ------ 71.47000
09-Aug-07 15100.15 ------ 71.47000
08-Aug-07 15307.98 ------ 71.47
07-Aug-07 14932.77 ------ 71.47
06-Aug-07 14903.03 ------ 71.47
03-Aug-07 15138.4 ------ 75.49
02-Aug-07 14985.7 ------ 75.49
01-Aug-07 14935.77 ------ 75.49
31-Jul-07 15550.99 ------ 75.49
30-Jul-07 15260.91 ------ 75.49
27-Jul-07 15234.57 ------ 77.03
26-Jul-07 15776.31 ------ 77.03
25-Jul-07 15699.33 ------ 77.03
24-Jul-07 15794.92 ------ 77.03
23-Jul-07 15732.2 ------ 77.03
20-Jul-07 15565.55 ------ 75.58
19-Jul-07 15550.13 ------ 75.58
18-Jul-07 15301.17 ------ 75.58

Please provide the solution with methodology to solve if possible asap. Thanks a lot.
 

oxusmorouz

Well-Known Member
#3
eh,the traditional method is to use r squared (also called as coefficient of determination). If this is an academic objective, r squared should do. Enclosing the excel sheet.

BTW, the question should be re-framed as "What % of movement in BSE is explained by crude?"
 
Last edited:

Similar threads