O$-$M$70/$ACCT$-2120-$U$70-$PRINCIPLES OF ACCT II

Isaac Ruiz

$07/11/248$:$02$ PM

ter $6$ HW $9$ LO $1-8$

Question $4,$ E$6-45$A $($similar to$)$

HW Score: $42\mathrm{.}86\%,3$ of $7$ points

Points: $0$ of $4$

The steps you will follow for this project are as follows:

Download the Excel data file. $($The Data Analaysis Toolpak is required to complete this project. The toolpak is not ava

Excel online. Click here for instructions on how to install the Data

Analysis ToolPak for Excel desktop.$)$

Click on the Video button on the bottom left or within the Get More Help menu for this question now. This tutorial video will walk you through this exercise, step$-$by$-$step.

Perform the requirements on the data file.

Check your work in the Excel file with these check figures.

Use your Excel file to answer the four multiple choice questions below. $($You will have to scroll down to see all of the questions.$)$

Resources

A$.$ Information on how to update Excel and Office $365.$

B$.$ If you do not have Office $365,$ click here to learn how to get it for free.

C$.$ Troubleshooting FAQ.

Using the Excel file and single regression you created for Tropic, what is the intercept coeffiecent?

A$.23,835\mathrm{.}55$

B$.0\mathrm{.}917175$

C$.20,086\mathrm{.}05$

D$.32\mathrm{.}99$

Using the Excel file and multiple regression you created for Tropic, what is the multiple R$?$

A$.20,086\mathrm{.}05$

B$.0\mathrm{.}915399$

C$.0\mathrm{.}958644$