Question

In: Math

Create an excel worksheet and populate it, in columns, with values of X that are -2,...

Create an excel worksheet and populate it, in columns, with values of X that are -2, -1, 0, 1, 2 and values of Y that are -1, 1,1,1,3. As an aside, note that the sample mean of X is 0. Create the columns shown below, and enter the proper formulas into excel.

(X minus

(X minus mean)

Mean)

times (Y

Y

Y-mean

X

X-mean

squared

minus mean)

Y-hat

u-hat

-1

-2

1

-1

1

0

1

1

3

2

sum

sum*1/n

B1-hat =

B0-hat =

Solutions

Expert Solution

(X minus (X minus mean)
Mean) times (Y
Y Y-mean X X-mean squared minus mean) Y-hat u-hat (x-mean)(y-mean)
-1 -2 -2 -2 4 4 4
1 0 -1 -1 1 0 0
1 0 0 0 0 0 0
1 0 1 1 1 0 0
3 2 2 2 4 4 4
sum 5 0 0 0 10 8 1 0 8
sum*1/n 1 0 0 0 2 1.6
B1-hat = 0.8
B0-hat = 1

Formulas used are:


Related Solutions

Create a balance sheet The adjusted trial balance columns of the worksheet for Ayayai Company are...
Create a balance sheet The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. Ayayai Company Worksheet (Partial) For the Month Ended April 30, 2019 Adjusted Trial Balance Account Titles Dr. Cr. Cash 11,500 Accounts Receivable 7,620 Prepaid Rent 2,180 Equipment 22,950 Accumulated Depreciation—Equip. 5,000 Notes Payable 5,800 Accounts Payable 4,500 Common Stock 20,500 Retained Earnings 8,550 Dividends 3,500 Service Revenue 15,500 Salaries and Wages Expense 10,800 Rent Expense 700 Depreciation Expense 600 Interest Expense 60...
Question 2 The adjusted trial balance columns of the worksheet for Indigo Company are as follows....
Question 2 The adjusted trial balance columns of the worksheet for Indigo Company are as follows. No ordinary shares were issued during April. INDIGO COMPANY Worksheet (partial) For the Month Ended April 30, 2017 Adjusted Trial Balance Account Titles Dr. Cr. Cash 7,099 Accounts Receivable 7,241 Prepaid Rent 2,491 Equipment 22,834 Accumulated Depreciation—Equip. 4,680 Notes Payable 5,613 Accounts Payable 5,569 Share Capital—Ordinary 21,320 Retained Earnings 4,887 Dividends 3,439 Service Revenue 12,434 Salaries and Wages Expense 9,933 Rent Expense 829 Depreciation...
Chapter 13: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and...
Chapter 13: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell C22 enter the formula "= B10". Note: The present value factors could be computed using the built-in Excel function PV, but we recommend using the formulas in Appendix 13B. Verify that your worksheet matches the example in the text. Check your worksheet by changing the discount rate to 10%. The net...
Chapter 9: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and...
Chapter 9: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B30 enter the formula "= B20". Notes: In the text, variances are always displayed as positive numbers. To accomplish this, you can use the ABS() function in Excel. For example, the formula in cell C31 would be "=ABS(E31?B31)". Cells D31 through D39 and G31 through G39 already contain formulas to compute...
Problem 4.-2: The trial balance columns of the worksheet for Firmament Roofing at March 31, 2014,...
Problem 4.-2: The trial balance columns of the worksheet for Firmament Roofing at March 31, 2014, are as follows. Firmament Roffing Trial Balance For the Month Ended March 31, 2014                                                                                                             Trial Balance_____                   Account Titles                                                           Dr.                            Cr.__ Cash                                                                                            2,720 Accounts Receivable                                                                 2,700 Supplies                                                                                      1,500 Equipment                                                                                11,000 Accumulated Depreciation – Equipment                                                                   1,250 Accounts Payable                                                                                                       2,500 Unearned Service Revenue                                                                                          550 Share Capital – Ordinary                                                                                          10,000 Dividends                                                                                    1,100 Service Revenue                                                                                                        6,300 Salaries and Wages Expense                                                   1,300 Miscellaneous Expense                                                              ...
Write CREATE TABLE and INSERT INTO statements in order to create and populate five tables in...
Write CREATE TABLE and INSERT INTO statements in order to create and populate five tables in Oracle’s SQL*Plus.The information you need about the database ARE IN THE CHARTS BELOW. Each worksheet includes the following information about its associated table: ➢ Column names (for example, the jr_order table contains the orderID, customerID, orderDate, orderStatus, and orderShippedDate columns); ➢ Column data types (for example, orderID is INT, orderStatus is VARCHAR2(2), etc.); ➢ Column constraints, if any (for example, orderID in the jr_order...
Create the 2018 budget for Buy-Right Bike Store (BRBS). Add a worksheet to your Project Excel...
Create the 2018 budget for Buy-Right Bike Store (BRBS). Add a worksheet to your Project Excel workbook for BRBC Budgeted Income Statement and create the 2018 budget using the following information. Budgeted Sales of Bike C: Online 75,000 bikes; instore 5,000 bikes. Bike C is purchased from Built-Right Bike Company, a sister company in the Biltmore Bicycle Corporation (BMBC), for $52 and is sold for $104. Inventory: Beginning inventory:      $    52,000 Purchases                            4,108,000 Sales                                                  ? Ending Inventory            ...
The trial balance columns of the worksheet for Crane Company at June 30, 2020, are as...
The trial balance columns of the worksheet for Crane Company at June 30, 2020, are as follows Crane Company Worksheet For the Month Ended June 30, 2020 Trial Balance Account Titles Dr. Cr. Cash 2,500 Accounts Receivable 2,200 Supplies 1,900 Accounts Payable 1,000 Unearned Service Revenue 380 Owner’s Capital 2,710 Service Revenue 3,100 Salaries and Wages Expense 490 Miscellaneous Expense 100        Total 7,190 7,190 Other data: 1. A physical count reveals $600 of supplies on hand. 2. $170 of...
The trial balance columns of the worksheet for Cullumber Company at June 30, 2020, are as...
The trial balance columns of the worksheet for Cullumber Company at June 30, 2020, are as follows. Cullumber Company Worksheet For the Month Ended June 30, 2020 Trial Balance Account Titles Dr. Cr. Cash 2,200 Accounts Receivable 2,400 Supplies 1,900 Accounts Payable 1,100 Unearned Service Revenue 370 Owner’s Capital 2,170 Service Revenue 3,700 Salaries and Wages Expense 640 Miscellaneous Expense 200        Total 7,340 7,340 Other data: 1. A physical count reveals $300 of supplies on hand. 2. $200 of...
The trial balance columns of the worksheet for Novak Company at June 30, 2022, are as...
The trial balance columns of the worksheet for Novak Company at June 30, 2022, are as follows. Novak Company Worksheet For the Month Ended June 30, 2022 Trial Balance Account Titles Dr. Cr. Cash 2,400 Accounts Receivable 2,640 Supplies 1,860 Accounts Payable 1,040 Unearned Service Revenue 420 Common Stock 3,100 Service Revenue 3,100 Salaries and Wages Expense 660 Miscellaneous Expense 100 7,660 7,660 Other data: 1. A physical count reveals $500 of supplies on hand. 2. $200 of the unearned...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT