1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

correlation coefficient - statistics analysis debugging.

Discussion in 'Excel Jobs, consulting gigs & freelancing' started by paulcherianc, Dec 30, 2018.

  1. paulcherianc

    paulcherianc Member

    Messages:
    105
    Hi,

    I have a statistical analysis report and would like to hire someone to fix the entire reports on the excel. I have got a serious issue on the correlation analysis. Basically, I dont know how to do this.

    had an assignments on statistics that i had a raw data related to smoking survey , the professor suggested to had to variables that we can compare which are (Age) and (BMI) for smoker . as well as (Age) and (BMI) for non smokers. i am not sure how to do the descriptive analysis for them as well as the following calculation that applied for two variables.

    i would like to compare two variables of smoker and non smokers both (ages) and (BMI) how they are related to each other for smoker people and non smoker person base on original survey data.

    I have done this report with the help of a freelancer and he is not able to explain how he did the correlation report.

    I have raised the questions as follows on the correlation sheet report.

    1.Why did he clubbed the BMI and Age of smoker and non smoker under column F and G?

    2. How did he get the value of t- as 0.675 with 967 degree f freedom.

    Can anyone review the entire report and correct it and explain me.

    Actually I dont have much time to submit this report. Can anyone help me please!
    Last edited: Dec 30, 2018
  2. vletm

    vletm Excel Ninja

    Messages:
    4,633
    paulcherianc
    Do You have data and clear vision of needed layout?
    It's challenge to give any answers to Your questions ... without any file!
  3. Ben Ponderin

    Ben Ponderin New Member

    Messages:
    1
    A sheet/workbook would help

Share This Page