Find the mean, median and standard deviation in Excel. Compare the mean vs. the median and discuss what this says about the shape of the variable’s distribution. Interpret the standard.

/in /by

Statistics

Instructions: Be sure to label the tables and graphs in a way that is understandable to someone who does not have access to the questionnaire or the raw dataset. For example, when reporting information about Question 5 from the questionnaire, use labels such as “Liberal” in the frequency table, not codes such as “1”. Format printed tables such that they are easy to read and do not overlap across several pages.

To include your Excel work in one document with your other homework problems, you may either copy and paste your output for the tables, or use the instructions for exporting your sheet, found on the Excel tutorial for the mean, median, mode and histograms.

 

  1. (3pts) Using question 14 (Q14) [How would you best identify yourself politically?]:

(a) Create a frequency table that shows counts/frequencies. Include a column count total. Remember, Categories and titles should be correctly labeled (that is, categories should not be labeled “1”,”2”,”3”, etc).

(b) Draw a bar chart for this distribution. Remember, Categories and titles should be correctly labeled (that is, categories should not be labeled “1”,”2”,”3”, etc).

(c) Is the class more liberal or more conservative, overall? Use specific numbers from your table and chart to support your answer.

 

  1. (3 pts) Using Question 4 (Q4) [What is your GPA?]:

(a) Find the mean, median and standard deviation in Excel.

(b) Compare the mean vs. the median and discuss what this says about the shape of the variable’s distribution.

(c) Interpret the standard deviation (describe what the standard deviation measures and what it tells you about your variable).

(d) Refer to the histogram below for this variable to discuss the features of this distribution (specifically, you should describe all of the following: (1) shape, (2) center, (3) spread and any possible (4) outliers).

(e) Find the values for the 5 number summary.

(f) Create a boxplot (stem and whisker plot).

 

Calculate the number of units completed during the period. Calculate equivalent units for conversion during the period. Calculate cost per equivalent units for materials.

/in /by

Accounting Question

Complete the following questions using Microsoft Excel. No other submission format is allowed. Review the grading rubric to confirm you are meeting the assignment requirements.

Consider the following information for Hamburg Corporation:

Items Units
Beginning inventory 85,000
Units started during the year 155,000
Ending inventory 61,000

Inventory is 100% complete as to materials and 60% complete as to conversion.

Items Materials Conversion
Beginning costs (SAR) 425,000 686,000
Costs added during the period (SAR) 1,255,000 980,000

Using the WEIGHTED AVERAGE method:

  1. Calculate the number of units completed during the period.
  2. Calculate equivalent units for conversion during the period.
  3. Calculate cost per equivalent units for materials.

Mannheim Corporation manufactures small camping tents and family camping tents. The estimated direct labor time to produce each type of tent is as follows:

Items Small Family
Estimated tents produced 24,500 11,000
Direct labor hours per tent 2.5 4.5

Estimated overhead for the period = 1,300,000 SAR.

  1. Compute the overhead cost assigned to each type of tent assuming direct labor hours are used to allocate overhead costs.

The controller is not satisfied with the traditional method of allocating overhead because he believes that most of the overhead costs relate to the family tent product line because of its complexity. He, therefore, developed the following three activity cost pools and related cost drivers to better understand the costs.

Activity Cost Pools Expected Use of Cost Drivers Estimated Overhead Costs (SAR)
Setting up machines 1,000 setups 25,000
Assembling 90,000 labor hours 980,000
Inspection 1,200 inspections 230,000
  1. Calculate the activity-based overhead rates for these three cost pools.
  2. Compute the cost that is assigned to each tent using activity-based costing system, given the following information.
Expected Use of Cost Drivers per Product
Items Small Family
Number of setups 130 825
Direct labor hours 29,000 55,000
Number of inspections 125 1,125
  1. What do you believe the controller should do and why?

You must show your work for credit.

 

Share your observations about what you have learned about the evolution of mathematics through the readings, videos, and your attempts to work with ancient instructions.

/in /by

Evolution of mathematics

Share your observations (400 words) about what you have learned about the evolution of mathematics through the readings, videos, and your attempts to work with ancient instructions.

 

Ten years ago, Amanda Cortez invested $20,000 in an account paying an annual interest rate of 5%. What is the value of the investment today? What is the interest on interest earned on this investment?

/in /by
  1. A company had cash and marketable securities worth $200,000 accounts payables worth $51,000, inventory of $1,501,500, accounts receivables of $5,288,128, short-term notes payable worth $220,000, other current liabilities of 100,000, and other current assets of $121,800. Calculate the company net working capital and describe how managers manage the firm working capital. (2 Marks)

 

  1. Your parents have given you $1,500 a year before your graduation so that you can take a trip when you graduate. You wisely decide to invest the money in a bank CD that pays 7% interest. You know that the trip costs $1600 right now and that inflation for the year is predicted to be 3%. Will you have enough money in a year to purchase the trip? Show your calculations. (2 Marks)

 

  1. If the following financial information related to XYZ Company. Total Revenues last year $970, depreciation expenses $50, costs of goods sold $450, and interest expenses $55. At the end of the year, current assets were $121 and current liabilities were $107. The company has an average tax rate of 35%. Calculate the net income for XYZ Company by setting up an income statement. (2 Marks)

 

  1. Calculate the common-size balance sheet from the following information for the company: (2 Marks)

 

Cash 50,000 Accts/Pay 25,800
Acct/Rec 60,000 Accrued expenses 30,000
Inventories 200,500 Short-term N/P 9,700
  Total Current assets 310,500   Current liabilities 65,500
Net fixed assets 132,000 Long-term debt 150,000
  Total assets 442,500 Total liabilities 215,500
    Owner’s equity 227,000
    Total liabilities and owners’ equity 442,500

 

 

  1. Ten years ago, Amanda Cortez invested $20,000 in an account paying an annual interest rate of 5%. What is the value of the investment today? What is the interest on interest earned on this investment? (2 Marks)

 

  1. You have just won a lottery that promises an annual payment of $120000 beginning immediately. You will receive a total of 15 payments. If you can invest the cash flow in an investment that is paying 8% annually, what is the present value of this annuity? (2 Marks)

 

  1. XXX company has forecast a rate of return of 20% if the economy booms (30% probability); a rate of return of 19% if the economy in in a growth phase (40% probability); a rate of return of 2.50% if the economy in in decline (20% probability); and a rate of return of -10% if the economy in a depression (10% probability). What is the company standard deviation of returns? (3 Marks)

 

 

Is there a significant relationship between the rewarding of creativity and innovation by employees and the employees’ length of service in the federal government?

/in /by

Contingency Tables and Interrelationship Analysis

Quantitative Analysis Report: Crosstabulation And Correlation Analysis Assignment

You will take part in several data analysis assignments in which you will develop a report using tables and figures from the IBM SPSS® output file of your results. Using the resources and readings provided, you will interpret these results and test the hypotheses and writeup these interpretations.

As doctoral students, your assignments are expected to follow the principles of high-quality scientific standards and promote knowledge and understanding in the field of public administration.

Apply a rigorous and critical assessment of a body of theory and empirical research, articulating what is known about the phenomenon and ways to advance research about the topic under review.

Research syntheses should identify significant variables, a systematic and reproducible search strategy, and a clear framework for studies included in the larger analysis.

Address the following research question using crosstabulations with the appropriate measure of association:

RQ 1: Is there a significant relationship between the rewarding of creativity and innovation by employees and the employees’ length of service in the federal government?

  1. Address the following research question using a Spearman rho correlation for ordinal variables:

RQ 2: Is there a significant relationship between the level of satisfaction with the policies and practices of senior leaders and the overall quality of work done by the employee’s work unit?

 

A trolley accelerates down a slope. Two photo cells spaced 0.5m apart measure the velocities to be 20cms-1 and 50cms-1. Calculate the time taken to cover the 0.5m. I’ve worked the acceleration out to be 21cms^2.

/in /by

Physics question urgently

  1. A car accelerates uniformly from rest and travels a distance of 60m in 6s. Calculate the acceleration of the car.

”Using a=2s/t^2 I get 3.3ms^2”

  1. A trolley accelerates down a slope. Two photo cells spaced 0.5m apart measure the velocities to be 20cms-1 and 50cms-1. Calculate the time taken to cover the 0.5m.

”Worked the acceleration out to be 21cms^2.”

 

The Prime National Properties Group is considering selling some of its educational facilities. Using the PMT function, calculate the monthly payments the company could expect.

/in /by

Week 7 Assignment

Note, for WK7 Assignment, upload the MS Excel document with the formulas and functions separately and place the complete MS Excel results (you are to hide all of the address fields and processing fee column and place your MS Excel results in your MS Word Document) in your final MS Word document.

The Prime National Properties Group is considering selling some of its educational facilities. The facilities have been tracked in an Access database. Shelly Williams, the President of the company, has asked you to prepare a report. Import the Access data in the file Facilities_Data as a table into Excel.

Using the PMT function, calculate the monthly payments the company could expect. The company would charge an 8% rate over 10 years. The result should be a positive number. Mr. Williams also asked you to calculate an extra processing fee for monthly loan payments using the IF function.

If a monthly loan payment is less than $6000, the company would charge a processing fee of $150; otherwise, there would be no processing fee. Filter the rows to display only those facilities where there is a $0 processing fee.

Hide all of the address fields and the processing fee column.

Save the Excel file as

  • Lastname_Firstname_Educational_Facilities
  • Lastname_Firstname_Educational_Report
  • Open the Word document Educational_Report, and then save the file as Lastname_Firstname_Educational_Report

Add a cover page of your choice, and then complete the content controls on the cover page.

In the report, format headings as Level 1 or Level 2, and then insert a table of contents on a new page.

In the worksheet, hide all of the address fields and the processing fee column

paste the Excel data into the Word document.

Add an appropriate heading formatted as Level 1, and then update the table of contents.

In each file, insechort the your name as a field in the footer

 

What is the optimal placement of cameras to fully observe every part of an octagonal house?

/in /by

 IB Mathematics Extended Essay

Research question is: What is the optimal placement of cameras to fully observe every part of an octagonal house?

This is for an International Baccalaureate Extended Essay.

Pick a real life building that you can apply this on. You can choose one that you want but you can refer to https://houseplans.bhg.com/plan_details.asp?plannum=8652 for the one the other author used.

 

In the world of finance, what does the following phrase mean? “Present Value or Present Value of Money” What does this mean to you? How will this affect an individual’s investment portfolio? How does this concechopt affect your retirement plans?

/in /by

Present Value (PV) or the Present Value of Money.

(1) Go to the Internet and find an article about Present Value (PV) or the Present Value of Money.

(2) Write the Article Title and Author’s Name in the Discussion Forum.

(3) Summarize the article – Minimum 150 words (DO NOT PLAGIARIZE – Use your own words)

(4) Answer the following questions at the end of your summary:

– In the world of finance, what does the following phrase mean? – “Present Value or Present  Value of Money”

– What does this mean to you?

– How will this affect an individual’s investment portfolio?

– How does this concechopt affect your retirement plans?

 

What is the optimal placement of cameras to fully observe every part of an octagonal house?

/in /by

 IB Mathematics Extended Essay

Research question is: What is the optimal placement of cameras to fully observe every part of an octagonal house?

This is for an International Baccalaureate Extended Essay.

Pick a real life building that you can apply this on. You can choose one that you want but you can refer to https://houseplans.bhg.com/plan_details.asp?plannum=8652 for the one the other author used.