Z-Score answer problem

[bhutani.sam]

Dear All

This is regarding Z-SCORE. In the attached sheet I would like to know how the answer is derived by Z-Score. I know how to get Z-Score figure (that I already calculated in the attached sheet). I just want to know in front of column no. 14 , How the answer -0.159907668 derived. For the proof of this answer (how I got this answer) ,I am attaching another sheet where someone else mentioned this figure in front of column 14 using Z-Score . Kindly advise.

Date				Z-SCORE- B	Z-SCORE-C
01-Jan-19​	10910.1​	27392.4​		1.80776869​	0.2007022​
02-Jan-19​	10792.5​	27174.7​		0.05881885​	-0.799363​
03-Jan-19​	10672.25​	26959.85​		-1.72954185​	-1.786337​
04-Jan-19​	10727.35​	27195​		-0.91009342​	-0.70611​
07-Jan-19​	10771.8​	27304.55​		-0.24903202​	-0.202861​
08-Jan-19​	10802.15​	27509.5​		0.20233387​	0.7386336​
09-Jan-19​	10855.15​	27720.4​		0.99055106​	1.7074614​
10-Jan-19​	10821.6​	27528.55​		0.4915947​	0.8261451​
11-Jan-19​	10794.95​	27453.9​		0.0952553​	0.4832195​
14-Jan-19​	10737.6​	27248.25​		-0.75765519​	-0.461491​	ANSWER		-0.159907668​	HOW ???
Mean	10788.55​	27348.71​
SD.Deviation	67.24035​	217.6857​

Best Regards,

Sameer Bhutani
++++++++++++++

 

[Dr.Peterson]

Please state the actual problem you are trying to solve, and explain what you did in words. You mention two sheets, but I see only the one spreadsheet, and there is no column 14, so I am very confused. (Do you mean the row for 14 Jan??) What do the columns mean? What is asked for?

 

[bhutani.sam]

Dr.Peterson

Lot of thx for your quick reply. Sorry if you could not get me well. I again try to make you understand what I had asked.
I mentioned some data in 2 different columns B and C. I need the result - 0.159907668 ,already mentioned in the sheet. ( I got this figure from someone else sheet) . My question is that how this answer is derived from the given data with Z-Score ???? Y es, I was talking about 14th Jan column.

In the attached file you can see the proof. In front of 14th JAN the figure -0.15997668 is written. I only want to know how is it derived ???
Hint : It is calculated with Z-Score.

I will be grateful to you.

 

[Dr.Peterson]

You haven't answered my questions.

I can see from the attachment the headings for the columns, which you omitted from yours: Close, Close (how are these different?), and "z-score spread". There also seems to be a cryptic explanation of what the column you are asking about might mean. And the fact that it is shown only in rows starting at row 11 suggests that it might be calculated from the first 10 rows, and perhaps the following entries are likewise calculated from the previous 10 rows.

(By the way, a "column" is vertical; a "row" is horizontal. What you are asking about is in the ROW for 14 Jan.)

Surely, if you want to duplicate this spreadsheet, someone has said what it means, haven't they? One can't just look at a number and tell you where it came from! Math is not magic, or mind-reading.

Possibly the people who answer questions about finance will have some ideas.

 

[bhutani.sam]

Sir,

I already replied to your first mail as soon as I got it. Didn't you get it ??? Can I have your whats app no. or your email address ?

Rgds

Sameer
+++++++++++

 

[Dr.Peterson]

Yes, I read and responded to your second post.

The problem is that you still didn't explain what the number you're asking about means. As I said, possibly someone else more familiar with such topics might be able to recognize what you are trying to do; or you might know more about it than you have said. I myself have no more knowledge about it to share with you.

 

[bhutani.sam]

Dr.Peterson

Good Day

Please check the attached file only and see how the result -0.15990668 is derived that is mentioned in front of 14th Jan. HINT : This figure is derived by Z-SCORE but I don't know how ????

Please try once again or ask any of your friends. It is important for me to know how this answer derived.

Rgds

Sameer
++++++++++++

 

[Dr.Peterson]

I already looked at it and commented.

If you want help, you must tell us whatever you know about what this spreadsheet is supposed to be doing. Surely it did not just appear on your computer with no explanation! Surely you have some idea what you want to use the number for!

Ask the person you got it from, if they didn't tell you anything previously. I am not a magician, to read your mind or somebody else's.