Question

In: Statistics and Probability

Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are...

Excel Assignment 2
Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are provided in previous assignment)
1. An Economist was interested in sex differences in the number of books a person reads (see file: Number of Books). Two random samples were taken, one of men and the other, and the number of books read during the last month was recorded. Is there a difference with respect to the number of books read by females and males?

Female Male
8 1
3 5
1 8
7 3
7 2
6 1
8 2
5 6
6 4
5 2
4 9
2 3
9 4
7 8
6 7
8 2
2 6
4 12
5 4
6 5
9 3
1 1
2 3
4 6
6 7
8 4
7 1
5 2
9 6
6 3
1
2
3

Solutions

Expert Solution

Answer:

Given that:

An Economist was interested in sex difference in the number of books a person reads (see file:Number of books).Two random samples were taken,one of men and the other,and the number of books read during the last month was recorded.


Related Solutions

2. Instructions: Use Excel to complete the following questions. Attach copies of the Excel pages or...
2. Instructions: Use Excel to complete the following questions. Attach copies of the Excel pages or embed the Excel work in your write-up. Marketing Graduate GPA (x) Starting Salary (y in thousands of dollars) 1 3.26 33.8 2 2.60 29.8 3 3.35 33.5 4 2.86 30.4 5 3.82 36.4 6 2.21 27.6 7 3.47 35.3 The marketing department at a large state university undertook a study to relate the starting salary (y) after graduation for marketing majors to grade point...
FINANCE ASSIGNMENT **THIS ASSIGNMENT REQUIRES THE USE OF MICROSOFT EXCEL** Refer to information page on the...
FINANCE ASSIGNMENT **THIS ASSIGNMENT REQUIRES THE USE OF MICROSOFT EXCEL** Refer to information page on the use of some finance features in Excel. Understand financial functions @PMT, @PPMT, @IPMT, @PV and @FV. See here. 1. Assume you are employed at $60,000 per year. Consider such deductions as social security, income taxes (federal, state and county) and your payment on health benefits. Do the best you can to come to grips with what is a realistic monthly take home pay. 2....
Use the Excel Template and the following information to answer the next three questions: Peterson Packaging...
Use the Excel Template and the following information to answer the next three questions: Peterson Packaging Inc. does not currently pay dividends. The company will start with a $0.50 dividend at the end of year three and grow it by 10% for each of the next seven years until it nearly reaches $1.00. After seven years of growth, it will fix its dividend at $1.00 forever. The required return on the stock is 15%. 1. (EXCEL TEMPLATE) What is the...
No excel please. Use the following information to answer the next three questions Today, a Spanish...
No excel please. Use the following information to answer the next three questions Today, a Spanish organization hedged a receipt of Canadian dollars by creating a portfolio consisting of five Canadian dollar futures contracts that mature three days from today. Each contract has 125,000 Canadian dollars attached. The futures price today is €1.225/C$. Assume that the initial margin and maintenance margin is €1500 and €1100 per contract, respectively. The closing futures prices over the next three days (days 1-3), in...
Instructions: Answer the last three questions using the information below. Microsoft Corp. (MSFT) Ratios Industry Average...
Instructions: Answer the last three questions using the information below. Microsoft Corp. (MSFT) Ratios Industry Average Ratio Three Year Company Ratio Results 2015 2016 2017 Year(s) Year Year Year Debt/Equity 0.96 1.178639661 1.687167521 2.33019311 Current 3.43 2.47340222 2.352881716 2.477273079 Quick Ratio 3.28 1.944246379 1.907778358 2.060858245 Return on Assets 5.49 0.069952697 0.091252316 0.097589713 Return on Equity 17.23 0.178219848 0.245866967 0.30844425 Net Profit Margin 11.57 0.130294935 0.196882325 0.235730962 Instructions: Discuss the following questions throughly (2-3 sentences). What does each ratio reveal about...
2. Solve using Microsoft Excel: Use the following data to find the equation of the regression...
2. Solve using Microsoft Excel: Use the following data to find the equation of the regression line. X-Bar 2 4 5 6 Y-Bar 7 11 13 20
​Use Lenz's law to answer the following questions concerning the direction of induced currents.
Use Lenz's law to answer the following questions concerning the direction of induced currents. Express your answers in terms of the letter labels a and b in each part of the figure below. (a) What is the direction of the induced current in the resistor R in Figure a when the bar magnet is moved to the left? a to b b to a The magnitude is zero. (b) What is the direction of the current induced in the resistor R after the switch S...
Please use Microsoft excel to solve the following questions. 1a) You borrowed a 15-year loan of...
Please use Microsoft excel to solve the following questions. 1a) You borrowed a 15-year loan of $1,000,000 from a bank. Interest is compounded monthly and the annual interest rate is 2.5%. Find the monthly repayment amount. 1b) You borrowed a 10-year loan of $1,200,000 from a bank. Interest is compounded monthly and the annual interest rate is 2%. What is the total interest expense of the loan? 1c) You borrowed $50,000 from a bank 2 years ago at an unknown...
INSTRUCTIONS Please read the following case study and then answer the three questions at the end....
INSTRUCTIONS Please read the following case study and then answer the three questions at the end. Copy/paste the questions followed by your answers into the Discussion Board. Remember to reply to one other person’s initial post with a minimum of four sentences. Module 4 Chapter 4 Ethics Discussion The discussion board assignment is Case 4 - 34 found at the end of chapter problems in your eTextbook. Your initial post should answer the two questions (a-b) posed at the end...
Instructions 1- You should use a Microsoft Office Word to accomplish this assignment. SABIC Corporation December...
Instructions 1- You should use a Microsoft Office Word to accomplish this assignment. SABIC Corporation December 01, 2017 Account Titles Cash $18,000 Supplies 3,000 Prepaid Insurance 600 Building 7,000 Account Payable 8,600 Notes Payable 1,200 Unearned Service Revenue 2,500 Common Stock 10,000 Dividends 500 Service Revenue 12,000 Salaries Expense 4,000 Rent Expense 1,200 Assumes the following adjustments data   1. Supplies on hand at December. 31 total $1000. 2. Expired insurance for the month is $100. 3. Depreciation for the month...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT