Question: I need to solve this linear statistics model problem by using excel Create a two page deliverable determining which variables impact soldier tasks. They were

I need to solve this linear statistics model problem by using excel

Create a two page deliverable determining which variables impact soldier tasks. They were weighed, their brain weight was predicted from an MRI, and they were given an electrolyte solution to drink. The data set includes a recording of the number of tasks a soldier was able to complete. created. Your paper is due by 0800 on the day of the exam. Email your report along with any Excel or R files (y) (x1) (x2) (X3) Number Body Brain Sugar Content of of tasks Weight Weight Electrolyte Solution 3 220 4 8.33 3 227.8 3.93 9.32 4 213.2 3.76 5.56 4 223.9 3.86 8.86 4 122 2.5 8.9 UT 206.1 3.83 9.6 5 223.8 3.91 5.42 193.2 3.64 7.24 6 198.9 3.95 8.54 172.3 3.68 9.95 7 194.1 3.86 8.32 8 163.9 3.73 7.02 8 168.9 3.68 6.88 153.7 3.49 6.63 9 169.1 3.9 9.14 10 146.8 3.69 8.7 10 155 3.65 7.34 11 167.3 3.92 7.73 11 142.8 3.67 8.37 12 126.9 3.32 7.28 12 140.9 3.61 9.46
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
