stat and excel

Get perfect grades by consistently using our writing services. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

For the first two problems below, refer to the spreadsheet “ttest HW.”

1.For this problem, refer to tab “q1.” There are two sets of data: Dataset 1 and 2. Plot both on a scatter plot and plot the linear regression line using Excel. Show the R2 value. Interpret these plots – what information can you extract about the direction and strength of the correlation?

2.For this problem, refer to tab “q2” This spreadsheet contains 7 pairs of distributions. Plot the distributions (one pair per plot) and perform two-tailed t tests for independent samples for each pair (α = 0.05). DO NOT use statistical software – show your work in a spreadsheet (without using the “TTEST” function in excel) and turn this in for credit. How are the distribution pairs different from each other? What is the same? How do the different parameters of the distributions effect the resulting p values?

3.You are designing an experiment to test the effectiveness of a new type of radiation therapy on prostate cancer. The primary endpoint of the study is to reduce mean rectal dose to the patient. How would you design the experiment? What type of statistical tests could you use?

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an excellent paper from our writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper