Category: Excel

follow instructions and complete the assignment. will attach one html file later

follow instructions and complete the assignment. will attach one html file later in the chat or link

MBA 504 Module Eight Excel Workbook Guidelines and Rubric
Overview
A dashboard i

MBA 504 Module Eight Excel Workbook Guidelines and Rubric
Overview
A dashboard is a collection of charts and analyses. Executive dashboards play a significant role in business intelligence. They provide vital information at a glance and a deeper understanding of an organization’s current situation. Dashboards are used as a point in time, a high-level view of a business or organization.
In this scenario, you will continue to work as a consultant trainee with the TC Ice Cream management team. The team has requested that you create a dashboard so leadership can effectively and efficiently have key insights about their sales revenue. Remember that TC Ice Cream is interested in whether specific trends are identified that can help grow its business through improved operations and sales. You are required to identify three key charts and a regression for presenting your analysis. The dashboard should depict clear insights from your analysis and findings.
Prompt
Specifically, you must address the following rubric criteria:
Identify key charts for the dashboard.Use your completed worksheets in the TC Ice Cream Excel Workbook to complete this step.
Identify three charts that you created in previous modules to include in your dashboard.
Create key slicers for the dashboard.Use the “Dashboard” sheet to create the dashboard.
You should have three slicers for the dashboard that interact with the three charts on the dashboard sheet.
The slicers will enable the dashboard user to filter (slice) the data by date and flavor.
Identify a key regression for the dashboard.Use your completed worksheets in the TC Ice Cream Excel Workbook to complete this step.
Identify one regression that you created in previous modules to include in your dashboard.
Create a table that summarizes the regression models created in previous modules.The table should show your dependent variable, independent variable(s), the linear regression formula, p values for the independent variable, and R2.
The table should consist of all five regression models created.
You do not need to paste the entire output of the regression models.
Create a dashboard that includes the following:Three key charts identified from previous modules
One table that summarizes the identified regression from previous modules
Slicers that interact with the three key charts on the dashboard sheet
A header and title
Create a PowerPoint Presentation to explain why you chose the identified charts and regression, including key visualizations and analysis to support your answers.Using the three charts you created in the dashboard, along with the slicers, display the charts summarizing your specific division and flavors you have used throughout the modules.
Display the regression table and provide a high-level analysis. Which of the regression models have a greater impact on the quantity sold variable for the division and flavors used throughout the modules?
What to Submit
TC Ice Cream Excel Workbook: Submit the TC Ice Cream Excel Workbook. For this assignment, work should be completed in the “Dashboard” sheet. Do not remove any sheets from the workbook.
PowerPoint Presentation: Submit a PowerPoint presentation using the Module Eight PowerPoint Template. If references are included, they should be cited in APA format. Consult the Shapiro Library APA Style Guide for more information on citations.
Requirements: section in workbook and powerpoint

R_3 ((Copy the relevant dataset sheet, based on your ERPsim ID supplied by the i

R_3 ((Copy the relevant dataset sheet, based on your ERPsim ID supplied by the instructor (found
in the “My Grades” section), to a new Excel Workbook. ))

In order to reduce errors you can set validation tests on entered data. This can

In order to reduce errors you can set validation tests on entered data. This cannot show if something is correct, but it can show if something is ‘wrong’ or ‘needs attention’ by virtue of not meeting specified criteria.
Open the file T3 – Expenses v2
The link should prompt you to sign into a Google account if you aren’t already, and to create a copy of the file for your own use.
The config tab contains some lists of data that we can use in the validation.
We’ll be applying validation to the Expenses tab. In each case where we apply our validation, we’ll apply it to a whole column, to allow for extra data being added, but you may wish to subsequently remove any validation from the top row of headers.
-Date column: since this is an expenses sheet, the entered date should not be later than today. Set the validation to allow only dates, and specify they must be earlier than or equal to today using =NOW() for ‘today’. Reject the input if the date is invalid, and write a suitable error message.
Try entering a date later than today to check if it works.
-Staff column: to make sure the name is always spelt the same you could provide a drop-down list to pick from.
-The list of staff is on the config sheet, at the top of column B. Make the whole column a named range. We’ll do the whole column to account for the possibility of new staff being added.
-Return to the Expenses tab and add a drop-down list validation to the Staff column,
using the named range you just created as the source of the list.
Configure it so values not in the list may also be entered.
-Category column: this could be another drop-down list, but as you
wouldn’t want staff inventing extra categories, it should be
configured so only values in the list are allowed. Start by
naming the list of valid categories in config!D:D.
-Cost column: there is already an IF function in column F to
check the value entered in column E, but the amount could
also be validated in column E itself. The value above which
entries need checking is defined in config!F1. Use this value
in a validation rule which will alert the user if the amount
entered into the Cost column is above the check limit, but
will still allow the entry to be entered.
Switch to the Summary tab.
-Cells B9:B12 need to count the number of claims made by each person. To do this you’ll need to use the COUNTIF function in each of the cells. Ensure your formula accounts for the possibility of more items being added to the list.
Hint: You’ll be counting in Expenses column B, and you should be able to reference the person’s name on the Summary sheet for the criterion.
-Cells C9:C12 need to show the total cost of expenses for each person. You will need to use the SUMIF function for this. Ensure it will remain correct if more items are added to the list.
Hint: the values for totalling are in Expenses column D, but the values for testing are in column B. As with COUNTIF you should also be able to reference the person’s name on the Summary sheet.
If all has gone well, trying making some changes:
-Change the check limit on the Summary sheet to a lower value (eg £10) and check the effect this has on the Expenses sheet.
-On the Expenses tab, add some more expenses (using the same staff names in column B).

I
need an excel answers i have the template and i have a pdf file with tasks in

I
need an excel answers i have the template and i have a pdf file with tasks in it just need the excel sheets

The doc below is Ch 2 Guided Project 2-3 pdf in that doc, there is detail on wh

The doc below is Ch 2 Guided Project 2-3 pdf in that doc, there is detail on what to do
, and after seeing the Ch 2 Guided Project 2-3 pdf you should do the work on Mail result doc. which is given below.

The details to the questions are uploaded as a word document. Also an example is

The details to the questions are uploaded as a word document. Also an example is uploaded as an Excel. This assignment must be completed as an Excel.

The doc below is Ch 1 Guided Project 1-3 pdf in that doc, there is detail on wha

The doc below is Ch 1 Guided Project 1-3 pdf in that doc, there is detail on what to do
, and after seeing the Ch 1 Guided Project 1-3 pdf you should do the work on Mail result doc. which is given below.

The doc below is Ch 3 Guided Project 3-3 pdf in that doc, there is detail on wha

The doc below is Ch 3 Guided Project 3-3 pdf in that doc, there is detail on what to do
, and after seeing theCh 3 Guided Project 3-3 pdf you should do the work on Mail result doc. which is given below.

A. Copy the San Diego County and Los Angeles County hospitals to a new worksheet

A. Copy the San Diego County and Los Angeles County hospitals to a new worksheet within this
worksheet. (Copy the rows holding the variable names and Los Angeles County and San
PH 307
2
Diego County hospitals as described in the Watch & Practice: Practice Skills for Assignment
1 video; do not copy the whole worksheet.) (3 pts)
B. Sort the hospitals by county. (2 pts)
C. Name this tab Los Angeles and San Diego. (2 pts)
D. Hide the columns that you won’t need to answer this question; do not delete columns. (2
pts)
E. In a new column, calculate the net outpatient revenue (est.) for each hospital located in San
Diego County and Los Angeles County. (Hint: You will need to refer to the OSHPD
documentation to determine how to calculate the net outpatient revenue.) Format with
1000 separator. (5 pts)
F. Using the appropriate function, calculate the mean net outpatient revenue (est.) for San
Diego and Los Angeles Counties combined. This can be placed in another new column or at
the bottom of the list of hospitals. Make certain to label this as “Mean.” (5 pts)
G. Using the appropriate function, calculate the median net outpatient revenue (est.) for San
Diego and Los Angeles Counties combined. This can be placed under the mean. Make
certain to label this as “Median.” (5 pts)
H. In the next empty column, use the appropriate function discussed in the videos to recode
the net outpatient revenue for each hospital as follows:
1) 0 if the net outpatient revenue is less than $30,000,000;
2) 1 if the net outpatient revenue is equal to or greater than $30,000,000.
Cell reference the criteria used in part
H. (5 pts)
I. In the next empty column, calculate the cost-to-charge ratio for each hospital located in San
Diego County and Los Angeles County. (Refer to the OSHPD documentation to determine
the correct formula.) Format as a percent. (5 pts)
J. Set up this worksheet as follows:
1) Include a header with your first and last names and the date the assignment is due in
the top right corner (1 pt);
2) Set the variable names to repeat at top and the facility number and name to repeat at
left for printing (2 pts);
3) Set the gridlines to print. (1 pt)
K. All numbers should be right-aligned. (1 pt)
PH 307
3
L. Show only the facility number, facility name, county name, type_control, the columns used
in the calculation, and the columns holding the information you calculated. (1 pt)