data cleaning problems

.xlsx

School

University Of Denver *

*We aren’t endorsed by this school

Course

4155

Subject

Accounting

Date

Jan 9, 2024

Type

xlsx

Pages

17

Uploaded by AgentZebra835

Report
Y X 196 57 206 58 222 71 216 67 219 69 223 70 226 70 213 68 232 76 228 75 207 60 218 68 201 58 226 70 231 74 244 79
Using a Regression Graph the relation
Y X 129000 Medium High 188000 Medium 195000 High 112000 Medium Low 195000 Medium High 125000 Medium 196000 Medium High 181000 Medium Low 134000 Medium High 174000 Low 196000 High 106000 Medium 130000 Medium 196000 Medium High 115000 High 157000 Medium 156000 Medium Using a regression, find the effect of the rating of X on the outpu Graph the relationship between the rating of X on Y.
ut Y.
Trans_ID Employee_ID Sale_Amount Commission_Rate Commission_Amount 1 E04 $ 38,000.00 2 E04 $ 13,000.00 3 E01 $ 27,000.00 4 EO1 $ 12,000.00 5 E02 $ 25,000.00 6 E01 $ 36,000.00 7 F02 $ 25,000.00 8 E02 $ 28,000.00 9 E02 $ 36,000.00 10 E04 $ 8,000.00 11 E01 $ 23,000,000.00 12 E03 $ 8,000.00 13 E03 $ 35,000.00 14 E02 $ 29,000.00 15 E4 $ 9,000.00 16 E04 $ 14,000.00 17 E01 $ 32,000.00 18 E01 $ 23,000.00
Calculate the commission amount for each transaction. Then, calculate the total commission for each of the employees. Refer to information on both a and b tabs.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help