Excel, statistics, pivot tables, V-Loopup, correlation tables, box plots

 

Crosstabs

Using the Supermarket data set, create crosstabs for Marital Status and Annual Income expressing the counts as percentages. Then, create a stacked 2D column chart. (Select the crosstab table and insert stacked 2D column chart). If you need to swap the x and y values, then right click on the chart, click select data, and switch row/column).

Box Plots

Using the Supermarket data set, create a box plots of Annual Income and Revenue. Which of the following income brackets appears to have the least variation in revenue (purchase amounts)?

Correlations

Using the Beta Employees data set, create a table of correlations between the variables Age, Prior Experience, Beta Experience, Education, and Annual Salary. (Look at Figure 3.18 in the example 3-3 document in Module 5 (Attached Image file for illustration purposes only). It shows a table of correlations like what you would need to produce. The bottom of the table shows the formula you would use to calculate the correlations for each cell.)

Pivot

Using the Supermarket data set, create a pivot table to find how many units were sold in total in the non-consumable category.

Complete explanation via a word document and completed Excel files using the given datasets and worked solutions in separate tabs on each applicable dataset file. Visual image instruction preferred

history reflection paper

 

Most ancient societies are patriarchal.  However, if you overlook the role of women in these civilizations, you miss a major piece of the puzzle when trying to understand what life was like in the past.   Read the (2) articles in Week 2 of Content titled Women in Ancient Egypt and Ancient Egyptian Doctor and include a response to the following in your Reflection Paper:

  • What freedoms and choices did Egyptian women have in their lives?  What was surprising for you to discover?
  • What was surprising to you concerning the role of women in the fields of medicine and healing?
  • How does this compare to the freedoms and opportunities of women in the workplace today? Where are conditions of equality favorable for women in the workplace, where is equality limited today?  Discuss at least 2 specific current situations, with evidenced support, involving gender in the workplace today. 
  • Begin with the articles provided and research these topics further on your own. 
  • Provide specific examples to support your points and conclusions – minimum 450 words.
  • Use and cite 3 outside sources using MLA formatting.

Fund of Data systems

Last week, you read a bit about some of the major historical innovations that were responsible for modern data management systems. If you had to think back to just the past twenty years, what modern technical innovation innovation do you feel has been instrumental in this most recent data evolution, 

  • Your initial entry must be 1 -2 paragraphs long. It must contain meaningful, researched and substantive content. 
  • Your entry must be unique. 
  • Your entries must contain a MINIMUM of three unique academic journal articles and research sources. Blogs, Wikis, and Online News Sources will NOT be accepted. I will spot check all entries. Any entry I find that is non-conforming to the cited source will receive an automatic zero as this is considered plagiarism. 
  • You must cite all references using APA and apply APA Style throughout the entire paper. 10% of your grade is based on APA Style.
  • You must spell check / grammar check your paper. 10% of your grade is based on following this criteria. 

Security governance

 

Security governance must be enforced at all levels of an organization. But many still do not understand quite what security governance is, what is its main objective, and how it should be integrated within existing structures in an organization.

In your own words briefly state (a) what  governance is from a security perspective, (b) it’s main objective, and (c) how should it be integrated into an organization. Please state your answer in 2 page paper in APA format.  Include citations and sources in APA style.

2 questions – Each question needs 3 answers – with 1 APA reference for each answer – Each answer atleast 200 words

Need 3 answers for each question.  1 APA reference MUST. APA 7th edition

Question 1:

Excel is probably the most popular spreadsheet software for PCs. Why? What can we do with this package that makes it so attractive for modeling efforts?

Question 2:

What are the common business problems addressed by Big Data analytics?  In the era of Big Data, are we about to witness the end of data warehousing? Yes/No Why?

Database homework

1Draw the corresponding ERD for the following Employee Database

2Normalize the following Schema with the given functional dependencies into BCNF
3Explain in your own words why the Student-Dept relation is not in 4NF. Then, convert the Student-Dept relation in 4NF. Also, provide the justification for each step you perform during normalization (4NF). Note: The SportActivity here means any sport a student is participating in. For example, a student with ID = 123 can participate in soccer and badminton
4In your own word, explain why do designers use Denormalization? What is the limitation of using Denormalization? Name and explain a better alternative approach than Denormalization.

Term paper: The ethics of software

Paper Requirements:

Required topic headings for your paper should include the background surrounding the issue, a historical perspective, current issues that are applicable, legislation dealing with this topic, examples, global dynamics/impact (such as issues, processes, trends, and systems),personal impact from a global perspective, and a summary.  These are the topics to be discussed in the term paperEach paper should contain a reference list of at least five (5) different substantial and quality references.  The references and reference citations for the term paper must be to a current event less than 3 years old (a reference with no date (n.d.) is not acceptable).  This requires a reference citation in the text of the paper and a reference at the end of the paper to which the reference citation applies. You must include some information obtained from the reference in your answer.  The references must be found on the internet and you must include a URL in your reference so that the reference can be verified.You cannot use information from the text book or any book/article by the author of the text book as a current event.  Make sure that your reference has a date of publication.The body of the paper should be a minimum of six typed double spaced pages.  Your cover page and reference page cannot be counted in this number.  You should use the APA format for your reference citations and the reference page.

Paper

Chapter 1 Paper: Review the Key Lessons from Chapter 1 – Explain the five key lessons and note the importance of each key lesson from chapter 1.  Also, note why is it important to understand these basic concepts.  (Information Technology and Organizational Learning Textbook) 

The above submission should be one page in length and adhere to APA formatting standards.