Sheet 1 in the Excel file (Framing Effects) contains data from a study conducted where a sample of participants was shown an image of a female in a picture twice, once with a red frame and once with a...

Sheet 1 in the Excel file (Framing Effects) contains data from a study conducted where a sample of participants was shown an image of a female in a picture twice, once with a red frame and once with a white frame. The dependent variable collected was their rating of how attractive the woman was in each condition, with higher values indicating greater attractiveness. a.You will use Excel to conduct a repeated measures t-test to evaluate whether there is a difference between conditions. b.You will provide the result as part of a small write-up, describing the research hypothesis and results of the data analysis. Your presentation of the result should be in appropriate APA style and include a graph of the group means with error bars. Lastly, you should write a conclusion describing what the results of the test mean in terms of the hypothesis. That is, what conclusion can we draw about the effect of frame color on attractiveness ratings? 2.Sheet 2 in the Excel file (Training Method) contains data from a study conducted where a sample of dogs was trained to walk on their hind legs, using either food or affection as the reinforcer. The dependent variable collected is the level of training achieved, with higher values indicating more successful training. a.You will use Excel to conduct an independent samples t-test to evaluate whether there is a difference between training methods. b.You will provide the result as part of a small write-up, describing the research hypothesis and results of the data analysis. Your presentation of the result should be in appropriate APA style and include a graph of the group means with error bars. Lastly, you should write a conclusion describing what the results of the test mean in terms of the hypothesis. That is, what conclusion can we draw about the effect of training method on success? Sheet 1 in the Excel file (Framing Effects) contains data from a study conducted where a sample of participants was shown an image of a female in a picture twice, once with a red frame and once with a white frame. The dependent variable collected was their rating of how attractive the woman was in each condition, with higher values indicating greater attractiveness. a.You will use Excel to conduct a repeated measures t-test to evaluate whether there is a difference between conditions. b.You will provide the result as part of a small write-up, describing the research hypothesis and results of the data analysis. Your presentation of the result should be in appropriate APA style and include a graph of the group means with error bars. Lastly, you should write a conclusion describing what the results of the test mean in terms of the hypothesis. That is, what conclusion can we draw about the effect of frame color on attractiveness ratings? 2.Sheet 2 in the Excel file (Training Method) contains data from a study conducted where a sample of dogs was trained to walk on their hind legs, using either food or affection as the reinforcer. The dependent variable collected is the level of training achieved, with higher values indicating more successful training. a.You will use Excel to conduct an independent samples t-test to evaluate whether there is a difference between training methods. b.You will provide the result as part of a small write-up, describing the research hypothesis and results of the data analysis. Your presentation of the result should be in appropriate APA style and include a graph of the group means with error bars. Lastly, you should write a conclusion describing what the results of the test mean in terms of the hypothesis. That is, what conclusion can we draw about the effect of training method on success?