Excel linear curve with standard error

%3CLINGO-SUB%20id%3D%22lingo-sub-1618155%22%20slang%3D%22en-US%22%3EExcel%20linear%20curve%20with%20standard%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618155%22%20slang%3D%22en-US%22%3E%3CP%3ECold%20someone%20help%20me%20with%20this%20problem%3F%20I%20would%20like%20to%20lax%20a%20curve%20(linear)%20to%20the%20data%20points%20with%20standard%20error.%20Thank%20you%20very%20much%20in%20advance%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1618155%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1623643%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20linear%20curve%20with%20standard%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623643%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F774231%22%20target%3D%22_blank%22%3E%40avolgyi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20Analysis%20add%20in%20to%20make%20a%20regression%20analysis%20for%20Response%202%20then%20Response%201%3C%2FP%3E%3CP%3Eyou%20find%20the%20results%20on%20the%20attached%20sheet%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Etell%20me%20if%20you%20need%20something%20else%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Cold someone help me with this problem? I would like to lax a curve (linear) to the data points with standard error. Thank you very much in advance for the help!

1 Reply

@avolgyi 

 

I used Analysis add in to make a regression analysis for Response 2 then Response 1

you find the results on the attached sheet

 

tell me if you need something else