In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Microsoft® Excel®. Answer the questions below in your Microsoft® Excel® sheet.
This assignment must be submitted as a Single Sheet Excel page!
In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Excel®. Answer the questions below in your Excel sheet:
1. Insert a new column in the database that corresponds to “Annual Sales.” Annual Sales is the result of multiplying a restaurant’s “SqFt.” by “Sales/SqFt.”
2. Calculate the mean, standard deviation, skew, and interquartile range (IQR) for each of the variables. (These should be at the bottom of the data set corresponding to each variable)
3. Create a boxplot for the “Annual Sales” variable. Does it look symmetric? Would you prefer the IQR instead of the standard deviation to describe this variable’s dispersion? Why?
4. Create a histogram for the “Sales/SqFt” variable. Is the distribution symmetric? If not, what is the skew? Are there any outliers? If so, which one(s)? What is the “SqFt” area of the outlier(s)? Is the outlier(s) smaller or larger than the average restaurant in the database? What can you conclude from this observation?
5. What measure of central tendency is more appropriate to describe “Sales/SqFt”? Why?
Note: To write the verbiages of your assignment, please use a single text box on the excel page and type your responses. Please see the example I attached below. If you have any questions, please ask not in a private message but in the course question section because my response to your question may help other students also.
Scenario: A company called Colony Nursery and Landscaping opened a new store located a few hundred miles away from its original location. The company wants to implement an award system that awards their customers with points whenever the customer makes a purchase, but the two stores are not able to share information. Colony Nursery and Landscaping will need to implement an enterprise resources planning (ERP) system that will solve the information silo problem by collecting and making available this user data. Colony Nursery and Landscaping is hoping that by providing customers with this award system, they will be able to maintain competitive advantage. Colony Nursery and Landscaping cannot afford to purchase, develop, or maintain this system on-site, so they are investigating cloud solutions. In addition, for many organizations, Cloud Nursery and Landscaping included, information silos make it difficult to tap into needed information. Discuss whether or not the problem of information silos can be solved by using the cloud. Some organizations do not have the resources to construct or maintain their computer infrastructure, so they utilize cloud services instead to reduce costs and improve scalability. In this assignment, you will discuss whether or not the cloud offers solutions for Colony Nursery and Landscaping and identify an application the ERP system could provide. Compose an assignment that includes the following elements:
Define what an information silo is.
Explain why information silos are a problem for organizations.
Discuss why organizations are moving to the cloud.
Determine whether or not using cloud services such as a cloud-based host for data storage would solve the ERP information silo problem at Colony Nursery and Landscaping.
Explain how using the ERP system and awards program would provide a competitive advantage for Colony Nursery and Landscaping.
Discuss why the implementation of an ERP system might require business process reengineering for Colony Nursery and Landscaping. Be sure to explain the business processes that will be affected such as the customer awards system as an example. Use diagrams or tables as needed, but this is not required.
Your assignment must be a minimum of two pages long (not counting the title and references pages), and it must be formatted in APA style. You should include an introduction section that gives background and context to your reader. You must use at least two scholarly resources as references. Any information from these resources must be cited and referenced in APA format.
For decades, relational databases remained essentially unchanged; data was segmented into specific chunks for columns, slots, and repositories, also called structured data. However, in this Internet of Things (IoT) era, databases need to be reengineered because the very nature of data has changed. Today’s databases need to be developed with the needs of IoT in mind and have the ability to perform real-time processing to manage workloads that are dynamic. For example, relational databases should be able to work with real-time data streaming and big data (an example was presented in the unit lesson).Scenario: eHermes wants their personnel to be able to view security video footage in real-time and provide them with the ability to query video footage for viewing. Choosing a database solution such as MongoDB would allow eHermes to store mobile self-driving video footage in the same database as the metadata. To do this, eHermes needs a way to manage the demands of real-time data streaming for real-time analytics. Conduct some research for a NoSQL database application such as MongoDB or Cassandra that could meet this need. How would switching to a real-time database solution help eHermes remain competitive? Create a PowerPoint presentation that does the following:
Provides a brief introduction to IoT.
Presents an argument to the eHermes CEO that switching to a more dynamic database structure (NoSQL real-time database) will meet the demands of IoT.
Introduces some features of the database you chose, whether it is MongoDB, Cassandra, or another database.
Describes how switching to a more dynamic database will give eHermes a competitive advantage?
Your presentation must be a minimum of six slides, and you must use at least two academic resources. Any information from a resource used must be cited and referenced in APA format.
Develop a disaster recovery plan for an organization. There are many different templates available online for you to use as reference and guidance. Your plan should cover the following sections (these sections detail the elements in a DR plan in the sequence defined by industry compliance standards ISO 27031 and ISO 24762):
Important: This section should summarize key action steps (such as where to assemble employees if forced to evacuate the building) and list key contacts with contact information for ease of authorizing and launching the plan.
Roles and Responsibilities
Purpose: To demonstrate your ability to analyze a business scenario and create a “real world” database
Assignment: Create a database for a small e-commerce web site. As a minimum, it should include the following entities:
Customer – name, address, city, state, zip, etc.
Inventory – description, category, quantity on hand, unit price, etc.
Order – date, payment info, etc.
OrderDetail – typical shopping cart line items
Supplier – vendor info to include MainPhone, SalesPhone, ShippingPhone, and BillingPhone
StateFees – list of 50 states and the sales tax and shipping costs
Inventory and Supplier start out as a N:M, so you’ll need to fix that
The fee info is: 1) Charge 6.25% tax in Texas 2) Charge 8.25% tax in California, 3) All other states have 0% tax…. and 4) Charge $4 to ship to TX, LA, OK, NM, 5) Charge $8 to ship to AK and HI, and 6) Charge $6 shipping to all other states.
Real databases do not always allow you delete records, so please account for this in your table design
Use the database diagram to ensure that there are no “orphan” tables
As a minimum, You must create Views, Table Functions, or Scalar Functions for the following:
query to produce the extended price (a single value) for a given Order and a given Line Item
query to show all order activity details for a given Customer
query to show the total cost (cost of items + tax + shipping) for a given order
query to show the total sales (in $) for each month
query to show the total sales (in $) for each category of product
create a view to demonstrate the use of each of the functions above
You need to have enough sample data in your database to be able to demonstrate that each query works
Notes: You must provide an MDF file from SQL Server 2017… not a later version!
Expectations: A single “detached” Microsoft SQL Server 2017 database file (an *.mdf file)
Question 1: If you could choose, would you want to be on the Project Board or be the Project Manager. What are the Pros and Cons?
Question 2: Why do you think the Project Board has to authorize each stage to be completed and to move on to the next?
Question 3: In your own words, explain how the Project Brief and the PID are related and what’s the difference between them?
Prepare a detailed outline of your paper. Your paper (and outline) must address the following points:
Describe the factors influencing the need for change and the imperatives for managing information assurance change initiatives.
Discuss how group and organizational dynamics may affect the success of your information assurance change initiative.
Evaluate the leadership style needed to successfully implement your information assurance change initiative.
Describe your change strategy and the potential resistance factors to be managed.
Describe the change model most appropriate for your information assurance change initiative.
Please refer Chapter# 12 from the attached textbook
Why do good requirements go bad? What can be done to prevent things from going bad?
Answer the question with a short paragraph, with a minimum of 250 words. Count the words only in the body of your response, not the references. APA formatting but do not include a title page, abstract or table of contents. Body and references only in your post.
A minimum of two references are required. One reference for the book is acceptable but multiple references are allowed. There should be multiple citations within the body of the paper. Note that an in-text citation includes author’s name, year of publication and the page number where the paraphrased material is located.
You will write a 2 page review/abstract/summary on an article from a peer-reviewed scholarly journal. This is to assess your ability to select and summarize the research of others, analyze and apply the research of others, and communicate professionally and effectively to their regard. However, the most important rationale for this assignment is for you to see how statistical analysis is presented.
No plagiarism. 2 page summary paper. Must follow all the instructions listed in doc.
Attached the document with all the detailed instructions listed in it.
Go through it before contacting me. Thanks.
Digital preservation can be defined as the long-term, error-free storage of digital information, with means for retrieval and interpretation, for the entire time span the information is required to be retained. Though this assessment holds true to the authors, business organizations continue to face significant challenges in meeting their LTDP needs, especially those organizations whose primary mission is to preserve and provide access to permanent records.
Looking at your identified industry for your paper, what considerations would have to be made in developing a long-term archival plan for a company within that industry?