Excel Case Problems

Anonymous

Question Description

Week 1 Assignments

Perform the following Case Problems for Excel Chapters 1. Submit your final solution workbooks under Wk1 Assignments

Excel Case Problems• Complete and solve these case problems:

o Case Problem Level 1: Filename: Computer Purchase.xlsx (See pp. 72-74)

o Case Problem Level 2: Filename: Job Analysis.xlsx (See pp. 74-75)

o Case Problem Level 3: Filename: CKG Sales.xlsx (See pp. 75-76)


Textbook: (2016). Succeeding in business with microsoft excel 2013: a problem solving approach

Authors: Gross, D., Akaiwa, F., & Nordquist, K. Publisher: Stanford, CT: Cengage Learning. ISBN: 978-1-28-509914-9

8 hours ago

FYI

Excel Chapter 1 - Applying Fundamental Excel Skills and Tools in Problem Solving

Everyone will know that they have mastered the material in the Excel textbook for Chapter 1 as they navigate through each level and are able to:

Level 1

  • Define common Excel error messages
  • Correct basic formatting problems in a worksheet
  • Correct errors in formulas
  • Understand precision vs. display of cell values
  • Level 2

  • Work with multiple worksheets
  • Calculate total, average, minimum, and maximum values with functions
  • Understand how functions work: syntax, arguments, and algorithms
  • Use the AutoSum feature to perform calculations quickly
  • Calculate the number of values using both COUNT and COUNTA
  • Level 3

  • Organize a workbook
  • Understand relative, absolute, and mixed cell referencing
  • Write formulas with different types of cell references
  • Copy formulas with different types of cell references
  • Name a cell or cell range
  • Unformatted Attachment Preview

    SAS 9.4 Intelligence Platform: Overview, Second Edition ® SAS® Documentation May 21, 2019 The correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2016. SAS® 9.4 Intelligence Platform: Overview, Second Edition. Cary, NC: SAS Institute Inc. SAS® 9.4 Intelligence Platform: Overview, Second Edition Copyright © 2016, SAS Institute Inc., Cary, NC, USA ISBN 978-1-62960-089-5 (Hard copy) ISBN 978-1-62960-090-1 (PDF) All Rights Reserved. Produced in the United States of America. For a hard copy book: No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written permission of the publisher, SAS Institute Inc. For a web download or e-book: Your use of this publication shall be governed by the terms established by the vendor at the time you acquire this publication. The scanning, uploading, and distribution of this book via the Internet or any other means without the permission of the publisher is illegal and punishable by law. Please purchase only authorized electronic editions and do not participate in or encourage electronic piracy of copyrighted materials. Your support of others' rights is appreciated. U.S. Government License Rights; Restricted Rights: The Software and its documentation is commercial computer software developed at private expense and is provided with RESTRICTED RIGHTS to the United States Government. Use, duplication, or disclosure of the Software by the United States Government is subject to the license terms of this Agreement pursuant to, as applicable, FAR 12.212, DFAR 227.7202-1(a), DFAR 227.7202-3(a), and DFAR 227.7202-4, and, to the extent required under U.S. federal law, the minimum restricted rights as set out in FAR 52.227-19 (DEC 2007). If FAR 52.227-19 is applicable, this provision serves as notice under clause (c) thereof and no other notice is required to be affixed to the Software or documentation. The Government’s rights in Software and documentation shall be only those set forth in this Agreement. SAS Institute Inc., SAS Campus Drive, Cary, NC 27513-2414 May 2019 SAS® and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product names are trademarks of their respective companies. 9.4-P5:biov Contents Chapter 1 / Value of the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 About the SAS Business Analytics Framework and the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Components of the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Strategic Benefits of the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . 13 About SAS Visual Analytics 7.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 About SAS Viya . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Chapter 2 / Architecture of the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . . . . . . . . Architecture Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Data Sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SAS Server Tier . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Middle Tier . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 17 19 20 23 23 Chapter 3 / Data in the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Overview of Data Storage Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Default SAS Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Third-Party Data Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Hadoop Data Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Parallel Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Multidimensional Databases (Cubes) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 How Data Sources Are Managed in the Metadata . . . . . . . . . . . . . . . . . . . . . 34 Chapter 4 / Servers in the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 Overview of SAS Servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 SAS Metadata Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 Server Objects, Application Servers, and Logical Servers . . . . . . . . . . . . 46 Load Balancing for SAS Workspace Servers, SAS Stored Process Servers, and SAS OLAP Servers . . . . . . . . . . . . . . . . . . . 49 Workspace Pooling for SAS Workspace Servers . . . . . . . . . . . . . . . . . . . . . . 49 Logging and Monitoring for SAS Servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 SAS Grid Computing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 iv Contents SAS LASR Analytic Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 Chapter 5 / Middle-Tier Components of the SAS Intelligence Platform . . . . . . . . . . . . 55 Overview of Middle-Tier Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 SAS Middle Tier Servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 SAS Web Infrastructure Platform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 SAS Content Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Chapter 6 / Clients in the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 Overview of Clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 SAS Add-In for Microsoft Office . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 SAS BI Dashboard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 SAS BI Portlets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 SAS Data Integration Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 SAS Enterprise Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 SAS Enterprise Miner . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 SAS Environment Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 SAS Forecast Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 SAS Information Delivery Portal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 SAS Information Map Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 JMP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71 SAS Management Console . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71 SAS Mobile BI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 SAS Model Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 SAS OLAP Cube Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 SAS Visual Analytics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 SAS Visual Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 SAS Web Parts for Microsoft SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 SAS Web Report Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 SAS Workflow Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 SAS Help Viewer for the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 Chapter 7 / Security Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 Overview of SAS Intelligence Platform Security . . . . . . . . . . . . . . . . . . . . . . . . 80 Authorization and Permissions Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 Roles and Capabilities Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 Contents v Authentication and Identity Management Overview . . . . . . . . . . . . . . . . . . . 84 Single Sign-On in the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . . . . 85 Overview of Initial Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 Encryption Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88 Security Reporting and Logging Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88 Recommended Reading . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 vi Contents 1 1 Value of the SAS Intelligence Platform About the SAS Business Analytics Framework and the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Components of the SAS Intelligence Platform . . . . . . . . . . . . . . . . . . . . . . . 3 Components Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Data Management Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 Business Intelligence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 Analytics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Supporting Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Strategic Benefits of the SAS Intelligence Platform . . . . . . . . . . . . . . . 13 Multiple Capabilities Integrated into One Platform . . . . . . . . . . . . . . . . . 13 Consistency of Data and Business Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 Fast and Easy Reporting and Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 Analytics Available to All Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 About SAS Visual Analytics 7.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 About SAS Viya . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 2 Chapter 1 / Value of the SAS Intelligence Platform About the SAS Business Analytics Framework and the SAS Intelligence Platform The SAS Business Analytics Framework encompasses a comprehensive set of business solutions, technologies, and services from SAS. Through this framework, organizations can address their most critical business issues and then add new functionality over time to enable continuous performance improvement. All of the functionality is available from one vendor and through one framework, thus reducing the total cost of ownership. The technologies that provide the foundation for the SAS Business Analytics Framework, as well as for industry and line-of-business solutions offered by SAS, are delivered through the SAS Intelligence Platform. The SAS Intelligence Platform is a comprehensive, end-to-end infrastructure for creating, managing, and distributing enterprise intelligence. It includes tools and interfaces that enable you to do the following: n extract data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data n store large volumes of data efficiently and in a variety of formats n give business users at all levels the ability to explore data from the warehouse in a web browser, perform simple query and reporting functions, and view up-to-date results of complex analyses n use high-end analytic techniques to provide capabilities such as predictive and descriptive modeling, forecasting, optimization, simulation, and experimental design n centrally control the accuracy and consistency of enterprise data With the SAS Intelligence Platform, you can implement an end-to-end intelligence infrastructure using software that is delivered, tested, and integrated by SAS. Using the tools provided in the SAS Intelligence Platform, you can create applications that reflect your unique business requirements and domain knowledge. Components of the SAS Intelligence Platform 3 Building on the technologies in the SAS Intelligence Platform, SAS offers solutions for industries such as financial services, life sciences, health care, retail, and manufacturing, as well as line-of-business solutions in areas such as customer management, enterprise risk management, and financial management. The solutions incorporate predictive analytics, industry and domain expertise, and specialized data structures. A complete set of documentation for deploying and administering the SAS Intelligence Platform is available at the following locations: SAS Intelligence Platform: Installation, Configuration, and Migration and SAS Intelligence Platform: Administration. The Help Center provides the primary administrative documentation for several software offerings, including the following: n SAS BI Server n SAS Enterprise BI Server n SAS Data Management (Standard or Advanced) and other related offerings for data management, data quality, and data governance The SAS Data Integration Server offering has been revised, and the SAS Enterprise Data Integration Server offering is available only through renewals. Administrators who manage SAS products that use the metadata server should use the documentation at this site. Supplemental guides provide additional details for other products and domains. Components of the SAS Intelligence Platform Components Overview The SAS Intelligence Platform includes components in the following categories: Data Management The data management components enable you to consolidate and manage enterprise data from a variety of source systems, applications, and technologies. 4 Chapter 1 / Value of the SAS Intelligence Platform Components are provided to help you cleanse, migrate, synchronize, replicate, and promote your data. In addition, SAS offers data storage options that are optimized for analytical processing, enabling you to quickly analyze and report on large volumes of data. Metadata for all of your intelligence resources is stored centrally and controlled through a single management interface. Business Intelligence The business intelligence components enable users with various needs and skill levels to create, produce, and share their own reports and analyses. Through easyto-use interfaces, users can obtain their own answers to business questions. Meanwhile, the information technology staff retains control over the quality and consistency of the data. Advanced Analytics SAS offers the richest and widest portfolio of analytic products in the software industry. The portfolio includes products for predictive and descriptive modeling, data mining, text analytics, forecasting, optimization, simulation, data visualization, model management, and experimental design. You can use any combination of these tools with the SAS Intelligence Platform to add extraordinary precision and insight to your reports and analyses. The following sections describe in more detail the data management, business intelligence, and analytics components, as well as key supporting components. Data Management Overview Data Management The software tools in the data management category enable you to consolidate and manage enterprise data from a variety of source systems, applications, and technologies. SAS provides access engines and interfaces to a wide variety of data sources, including the following: n delimited files, SAS data sets, and relational database management system (RDMS) tables n Hadoop file systems for handling big data Components of the SAS Intelligence Platform 5 n application data from enterprise resource planning (ERP) and customer relationship management (CRM) systems n message queuing platforms n web services n unstructured and semi-structured data Data storage options include simple relational databases, a threaded multidimensional database that supports online analytical processing (OLAP), and relational storage with a threaded multiple input/output (I/O) subsystem for intensive use by focused applications. Each of the data management solutions is described briefly in the following sections. SAS Data Integration Studio SAS Data Integration Studio is a visual design tool that enables you to consolidate and manage enterprise data from a variety of source systems, applications, and technologies. The software enables you to create jobs and process flows that extract, transform, and load data for use in data warehouses and data marts. You can also create processes that cleanse, migrate, synchronize, replicate, and promote data for applications and business services. SAS Data Integration Studio is part of the following offerings: SAS Enterprise Data Integration Server (renewals only), SAS Data Integration Server, SAS Data Management Standard, and SAS Data Management Advanced. For more information, see Chapter 6, “Clients in the SAS Intelligence Platform,” on page 61. SAS Data Loader for Hadoop SAS Data Loader for Hadoop is a software offering that makes it easier to move, cleanse, and analyze data in Hadoop. It enables business users and data scientists to do self-service data preparation on a Hadoop cluster. Hadoop is highly efficient at storing and processing large amounts of da ...
    Purchase answer to see full attachment

    Tutor Answer

    pallveechem123
    School: Boston College

    Please find attached the complete work. Kindly update in case of any confusion

    Computer Price Comparison
    Laptops
    features

    Dell Laptop

    Sony Laptop Lenovo Laptop

    Processor and
    processor speed
    RAM
    HARD Drive
    Display
    DVD Features

    SonVAIO
    Dell Latitude E65
    BZ56
    Intel Core 2
    Intel Core 2 Duo
    Duo
    Processor,
    Processor,
    2.53GHz
    2.53GHz
    3 GB
    2 GB
    250 GB
    250 GB
    15"
    15.4"
    DVD r/w
    DVD r/w

    Battery
    Camera and
    accessories

    Long life battery
    video camera
    and video card

    builit in
    camera

    video card

    Windows 7
    Proffessional

    Windows 7
    Proffessional

    Windows 7 Home premium

    Model Name

    Windows Version

    Connectivity

    Wifi/Bluetoo
    Wifi/Bluetooth/
    th/
    Broadband
    Broadband

    Lenovo Think Centre W5

    Intel Core 2 Duo Processor,
    2.53GHz
    2 GB
    150 GB
    15.4"
    DVD recordable device
    -

    Wifi/ Broadband

    3 year warranty
    incl. Shipping
    $
    1,749.00
    -

    Warranty
    Basic Rate
    Processor
    RAM
    HARD Drive
    Windows 8 Pro
    Camera Built in
    Bluetooth Collection
    Long Life Battery
    DVD Recordable DeviceVideo Card
    Full 3 year warranty Carrying Case
    $
    Shipping
    Total

    1 year
    warranty
    1 year warranty incl. Shipping
    $ 1,449.00 $
    1,104.00
    $
    130.00
    $
    59.99 $
    60.00
    $
    69.00 $
    29.00
    $
    30.00
    $ 149.00 $
    70.00
    $
    115.00
    $ 249.99 $
    195.00
    79.95 $
    65.00
    46.00 -

    1828.95

    2022.98

    1798.00

    Discounts offered
    Rebate

    18%
    Discount on
    Rebate of $150
    everything
    per machine
    but shipping No Discount
    150
    355.8564 -

    Cost of one compute...

    flag Report DMCA
    Review

    Anonymous
    I was on a very tight deadline but thanks to Studypool I was able to deliver my assignment on time.

    Anonymous
    The tutor was pretty knowledgeable, efficient and polite. Great service!

    Anonymous
    I did not know how to approach this question, Studypool helped me a lot.

    Studypool
    4.7
    Trustpilot
    4.5
    Sitejabber
    4.4
    Similar Questions
    Related Tags

    Brown University





    1271 Tutors

    California Institute of Technology




    2131 Tutors

    Carnegie Mellon University




    982 Tutors

    Columbia University





    1256 Tutors

    Dartmouth University





    2113 Tutors

    Emory University





    2279 Tutors

    Harvard University





    599 Tutors

    Massachusetts Institute of Technology



    2319 Tutors

    New York University





    1645 Tutors

    Notre Dam University





    1911 Tutors

    Oklahoma University





    2122 Tutors

    Pennsylvania State University





    932 Tutors

    Princeton University





    1211 Tutors

    Stanford University





    983 Tutors

    University of California





    1282 Tutors

    Oxford University





    123 Tutors

    Yale University





    2325 Tutors