Categories
Writers Solution

How to Install the Data Analysis ToolPac in Microsoft Excel

Instructions

In this assignment, you will be required to calculate descriptive statistics for each numeric variable in the Heart Rate Dataset

Steps

  1. Open the Heart Rate Excel Dataset In Read Me First
  2. Sort the quantitative variables by class (e.g., Male at-rest heart rate and Female at-rest heart rate)
  3. Use the Excel Data Analysis ToolPak* tools to calculate each of the following statistics:
    1. Mean of each quantitative variable
    2. Sample variance of each quantitative variable
    3. Sample standard deviation of each quantitative variable
  4. Create a table in Excel that summarizes the statistics for each variable.
  5. Transfer your summary results to Word.
  6. Interpret what the mean and standard deviation specifically tell you about the heart rates of males and females in the sample.  Are the heart rates for males or females higher?  Which data is more spread out and which is closest to the overall mean rate? Explain your responses.

In the topic “Measures of Center”, you were provided directions on how to upload the Data Analysis ToolPak to Excel. If you have not yet uploaded the add-in Data Analysis ToolPak, please view the appropriate video and follow the instructions.  You will not be able to complete this assignment without that add-in.

How to Install the Data Analysis ToolPac in Microsoft Excel

How to Add the Data Analysis ToolPak in Excel on Mac 2018

Installing Excel Toolpak (Data Analysis) on Mac (versions other than 2018)

For a review of how to use the Data Analysis ToolPak to create summary statistics

Review: Descriptive Statistics in Excel Mean, Median, Mode …

Directions: Review this video on how to use the Data Analysis ToolPak to create summary statistics. 

Additional Instructions:

Your assignment should be typed into a Word or other word processing document, formatted in APA style. The assignments must include

  • Running head
  • A title page with
    • Assignment name
    • Your name
    • Professor’s name
    • Course

References

Ben G Kaiser. (2018).  How to add the Data Analysis ToolPak in Excel on Mac 2018 [Video]. Retrieved from https://youtu.be/HJay_paA6T4

Joseph C. (2016). Installing Excel Toolpak (Data Analysis) on Mac [Video].  Retrieved from https://youtu.be/mtmrAXwLcuU

Joshua Emmanuel. (2017). Descriptive statistics in Excel mean, median, mode, std. deviation… [Video]. Retrieved from https://youtu.be/qJR8OMQP3vw/p>

Quantitative Specialists. (2013). How to install the Data Analysis ToolPak in Microsoft Excel [Video]. Retrieved from https://youtu.be/_yNxLFagKgw

WE HAVE DONE THIS ASSIGNMENT BEFORE, WE CAN ALSO DO IT FOR YOU

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER on  How to Install the Data Analysis ToolPac in Microsoft Excel

Are You looking for Assignment and Homework Writing help? We Provide High-Quality Academic Papers at Affordable Rates. No Plagiarism.

TO BE RE-WRITTEN FROM THE SCRATCH

Categories
Writers Solution

A publicly traded home builder has hired you to install a new wireless network Secure Service

First Section 

In a 350- to 500-word essay, address the 4 questions. 

Case study: A publicly traded home builder has hired you to install a new wireless network. The company currently has a wireless network that is a few years old. The problem with the current wireless network is that it was built using proprietary standards instead of 802.11. This current wireless network does not have an upgrade path to 802.11.

On the new wireless network, the corporate office wants a system that allows construction workers to enter progress reports into the system in order to stay up-to-date with all the different community building sites. Each community has a model home that will need Wi-Fi to connect back to the corporate office in order to enter these reports. The construction workers will be using iPads to enter the information. The company currently has 32 sites across the country that will need Wi-Fi. 

In each of these sites, there will be two sales employees that will need to have Wireless IP Phones so that customers can get in touch with them easily. The sales employees will also have laptops, as well as two sales kiosks that allow customers to browse the different options to choose from for their new home build. The kiosks will connect to the Internet, and when the customer chooses their options, the information will be entered into a database. Once the customer chooses the options they want, the sales person will pull up the report on their laptops to print for the construction workers. 

Directions: Looking at the current wireless network and what the home builder would like to accomplish with the new network, explain to the company why the current wireless network will have to be replaced before you can begin the project. The Chief Information Officer (CIO) has asked you to come up with a plan to implement this new wireless network. Include in your report:

1. A brief description of the problem with the current wireless network

2. The benefits of global/industry standards vs. proprietary standards

3. What types of problems exist with mixed standards 

4. A plan to correct the problems with the current wireless network

__________________________________________________________________________________

 Second section…. 

1. PROJECT SCOPE –

Project scope

2. FEASIBILITY STUDY –

Objectives of the Network:

1. Secure Service – What is the main objective of this network? 

2. Integration and Updates –What needs to be done to get the current network up-to-date?

3. Versatile Information Process –What does the network need to be able to do? For example, applications, devices, computers, laptops, etc. 

4. Collaboration – How will the network be used to collaborate with other offices? Other users in a different location?

5. Scalability – How will the network be able to adapt to change?

Intended Users –What type of mobility requirements, client device requirements, and signal coverage requirements are needed?

Design Assumptions – State the assumptions for unknown factors that could affect the project. 

Equipment Needs and Proposed Budget

Categories
Writers Solution

In a corporate, networked setting, should end users be allowed to install applications on their company workstations, whether the applications are on a DVD or downloaded from the Internet?

1) In a corporate, networked setting, should end users be allowed to install applications on their company workstations, whether the applications are on a DVD or downloaded from the Internet? Be sure to weigh security against usability.

2) For this assignment, you are asked to locate any company privacy policy. Some of the more popular ones might include GOOGLE, APPLE, or MICROSOFT, but you may elect to review another agency. In 3- 4 paragraphs, explain what you find to be the most interesting information contained in that privacy policy. At the end of your report, please include a LINK to the policy you have reviewed. 

3)   For your discussion board post please locate the latest annual report for a publicly traded corporation of your choice. Attach a link or copy of the annual report to your post. In your post describe what is found in an annual report. For example, what are the different sections that can be found in them from what you see? Lastly, be sure to locate the income statement, balance sheet, and cash flow statement. List in your post which pages you found these on. 

4)This week we are learning about financial statement analysis and how to compute various ratios. This is a great way to understand how a company is doing. However, what are some limitations of financial statements analysis? Meaning, what are some things which make financial statement analysis less reliable? Do some research on this and post your thoughts on what you find. 

5) For the week eleven discussion board I would like you to take a look at Problem 12-51 on page 548. That problem asks you to visit the website of Citibank and then to answer 4 questions. For this discussion board I ask each of you to pick a different publicly traded company. After researching the company answer the 4 questions listed. Be sure to provide specific details in your post that you found on the website for the company you chose. Be sure to provide a link to the website of the company you chose to use for this assignment.