I need to calculate adjustment charitable contribution for corporation. The contribution paid in cash.

                                                             debit                             credit

net sales                                                                              3,750,000

dividends                                                                              29,000

Interest                                                                                  12,000

Gain on sale of stock                                                             35,000

Key-person Life ins.proc                                                            110,000

GOS                                              2,150,000

Salaries & wages                               460,000

Bad debts                                        16,000

Payroll Taxes                                    90,000

Interest expense                                  22,000

Charitable contribution                       130,000

Depreciation                                       55,000

Other expenses                                 50,000

Federal income taxes                         272,782

Net income /Taxable income

before special deductions                    690,218

Total                                                 3,936,000                            3,936,000

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Please help me plot this data in excel. I need to calculate the percent error…I need help as soon as possible. Everytime I try to right click in Excel the data will not work. Thank you!

1.    Open Excel
2. Start a new workbook in EXCEL.
3.           Enter the following experimental data:
4.                   For row A1 enter “x”.
5.                   In row A2 enter “0.110”.
6.                In row A3 enter “0.125”.
7.                 In row A4 enter “0.150”.
8.                In row A5 enter “0.210”.
9.                   In row B1 enter “y”.
10.                   In row B2 enter “1.08”.
11.                In row B3 enter “1.32”.
12.                 In row B4 enter “1.58”.
13.                In row B5 enter “2.04”.
14.            Finish entering data.
15. The next part is to graph the data and then complete a curve fit which we will skip. The curve fit will give the equation y = 9.23x + 0.13. Use this equation to calculate the predicted y or yfit.
16.            In row C1 enter “y fit”.
17.            In row C2 enter “= 9.23*A2 + 0.13”.
18.            Click to select row C2. Then left click twice on the lower right corner of C2. This will calculate for row C3 – C5.
19. Now calculate the square of the error
20.       In row D1 enter “Error squared”
21.            In row D2 enter “= (B2 – C2)^2”.
22.            Click to select row D2. Left click the lower right corner twice to repeat the calculation for rows D3 – D5.
23. Now calculate the root mean square error.
24.           In row D6 enter ” = sqrt( Average(D2:D5) )”.
25.           When this is done you should have a value of 0.0516 in row D6. This is the rms error.
26. To calculate the percent error of the fit, calculate the average of the |y|.
27.           In row E1 enter “Abs(y)”
28.           In row E2 enter ” = abs(B2)”.
29.           Click to select row E2. Left click twice on the lower right corner of E2 to calculate for row E3 – E5.
30.         In row E6 enter ” = Average(E2:E5)”.
31. You should have a value of 1.505 in row E6.
32. Now calculate the percent error
33.      In row F1 enter “Percent error —>”
34.          In row G1 enter ” = D6/E6*100″.
35. Now repeat with a new set of data and answer the question below.
36. Question: Enter the experimental data below into an EXCEL workbook.
37.        Height difference    Acceleration
38.                0.110           1.05
39.                   0.125           1.34
40.                 0.150           1.54
41.                   0.210           2.10
42. The equation of the best-fit line is y = 9.97x + 0.02. What is the percent error of the fit? Use 3 decimal places.

I need the answer for the percent error =_______

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I need to complete 2 papers for a school counseling program. The login to my course can be given to retrieve additional information and resources to complete the writing assignments.

Please see attached document for details related to the papers. 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I need to complete the return on shareholder’s equity ratio as well as the return on net assets ratio. I don’t know what numbers I need to take to complete the ratios from this attached income statement.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I need to construct a realistic hierarchy to determine the popular vote of the Presidential election. It should have a criteria, sub-criteria and alternative for selecting a president. Can you please help me with this question. Thank you.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"