Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Hi Experts,

I have prices in column A & variables in column C D E F. I want formula for*t Stat* & *Coefficients*.

I had done via Tab - Data - Data Analysis - Regression - Results in same sheet which is look like this But I want only blue highlighted Cell results via excel formula.......any idea?

See attached file.

stat.xlsx

I have prices in column A & variables in column C D E F. I want formula for

I had done via Tab - Data - Data Analysis - Regression - Results in same sheet which is look like this But I want only blue highlighted Cell results via excel formula.......any idea?

See attached file.

stat.xlsx

http://formulas.tutorvista.com/math/anova-formula.html

gowflow

just to recheck what am I achieving is right or wrong?

stat.xlsx

stat.xlsx

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_21791623.html

gowflow

May I reframe the new question as I don't found any Formula. I found macro recording is working. so I thought just go ahead with this same question link with same question next step.

Pls Reply

Thanks

Thanks

Stat-2.xlsx

Thanks

Thanks

Thanks

if you wish to understand than read this as this technical part of this.

Purpose of doing this - by finding duration of cycle we can pin point low or high of stock price. we just need to find where we are in cycle & we can predict future high & low. this is very early stag of this there 3 or 4 more cycles.

apology that I cant make you understand perfectly what I want & you invested your time in this Code but I gona use this Code surly.

Thanks

anyway anything wrong in the macro please let me know.

gowflow

Please do not forget to post a link of the new question if you need my help.

gowflow

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Open in new window

Active macros and try the attached file.

Let me know

gowflow

Stat-2.xlsm