Category: Excel

Instructions will be uploaded later.
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)

For the Control Chart Assignment you will have a chance to practice your skills by creating and analyzing control charts for 5 different sample readings. Use Excel template provided and the Sample Data 1 to answer Q1, Sample Data 2 to answer Q2 etc. You will enter the sample data representing the number of defect into the Green Shaded Cells.
The spreadsheet is set up to calculate the following key elements of information that you can use to analyze what is going on with each process scenario.
For this exercise you are the PM for your project and have taken a series of 15 readings over 15 days to measure the number of defects in your process. Once you enter the data set the spreadsheet will generate the control chart plot.
For each of the 5 scenarios perform the calculations, and then interpret the control chart and state if the process is in control or not along with supporting rational. Include a screen shot of your plot when discussing your analysis for each scenario.
Your analysis should also include comments and observations on the process when the Z value (Sets the Control Limits) is changed. What if you move from 2 to 3? What is the impact?
Control Chart Exercise (Student)-1.xlsx Download Control Chart Exercise (Student)-1.xlsx 
Refer to the 8 tests (or rules) in the lecture slides and on pages 133-135 of Pocket Toolbook.  
When using the spreadsheet:
The Z value sets where the control lines are drawn in the graph. The results box lists the standard deviation. If you change the Z value to 1 you will see that the control limits are drawn at 1 standard deviation which represents Zone c. If you change the Z value to 2 the control limits are drawn to outline the B zone and 3 the A zone. You can change the Z values to outline the Zones and make it easier to apply the 8 Shewart (Western Electric) Rules to each data set to determine if the data is out of control and if it is by what rule. 
Let me know if you have any questions.

I will upload three excel files. You will have to make the first and the second table with the same formulas and editing as the third one. (Bolaffi 1999 and Bolaffi 1996 have to be the same format as Bolaffi 1997). They have to be equal to “Display Tab”.

1) Use the 3-month LIBOR as attached: 3month_LIBOR.xlsx ( 3month_LIBOR.xlsx ).
2) Download daily “3-month Treasury Constant Maturity Rate” from Jan. 2, 2019, to Dec 29, 2023. (https://fred.stlouisfed.org/series/DGS3MO) 3) Compute the daily average rate of return and standard deviation with a 3-month T-bill rate over the sample period,
4) Plot the cumulative rate of return (X-axis: Date, Y-axis: Cumulative Return) from 3). Explain the plot thoroughly. please explain how you did each part

Please watch the contents of the document carefully, especially the introductory video and workbooks

Data in the Excel File Microprocessor Data.xlsxshows the demand for one type of chip used in industrial equipment from a small manufacturer.
Construct a combo chart of the data. What appears to happen when a new chip is introduced?
Develop a causal regression model to forecast demand that includes both time and the introduction of a new chip as explanatory variables.
What would the forecast be for the next month if a new chip is introduced? What would it be if a new chip is not introduced?
Instructions:
Write your answer in a Microsoft Excel document. Include the data set. Criteria: 1. Chart of the data, 2. What appears to happen when a new chip is introduced? Conclusion from the chart,
3. Causal regression model Calculation tables and model, 4. Forecast be for the next month if a new chip is introduced, 5. Forecast be for the next month if a new chip is not introduced

For
this project, think of a situation in business/organization or in your personal
life where you can apply the analysis and tools we learned throughout the
semester to improve or automate decision-making. You can use
functions, pivot table, macros, as well as things beyond what you leaned in the
class.
The
goal is that application of these tools can help the business/organization to
run more efficiently or effectively. There are two general directions you can
take to achieve this goal:
·     
extract insights from data to help firm improve their operations
or make better decisions,
·     
automate certain operations so that it is easier for users/decision-makers
to search and access information or insights.
You
can pick one of them or do a hybrid of both.
Submission
Your
final submission should include an Excel file with your data and
analysis and a recorded presentation with slides that explain: 1. The
scenario 2. How your analysis/automation help with the business/organization. 
I
am grading your project mainly based on two aspects.
·     
The technical aspect: whether the tools you use is appropriate
for the analysis and the sophistication level of the tools
·     
The business aspect: whether you are solving a meaningful
problem (to aswer the “so what” question)

This work is already done I just need someone to me the excel sheet, same to the attached photo. The Lazer Company has a contract to produce a part for Boeing Corporation that must have an average diameter of 6 inches and a standard deviation of 0.10 inches. The Lazer Company has developed a process that will meet the specifications for the standard deviation, but it is still trying to meet the mean specifications. A test run (considered a random sample) of parts was produced, and the company wishes to determine whether this latest process that produced the sample will produce parts meeting the requirement of an average diameter equal to 6 inches.
Use Excel to:
Construct the appropriate null and alternative hypotheses with correct parameters.
Develop the decision rule assuming that the sample size is 200 parts and the significance level is 0.01.
In a Word document:
Recommend what the Lazer Company should conclude if the sample mean diameter for the 200 parts is 6.03 in

In the Personal Financial Plan last submitted under Project 4 turn to the Chapter 17 tab. You will be comparing different options for sector mutual funds. Please take a look at several mutual funds before choosing one. The Financial Times offers a very Once you have chosen a sector and mutual fund go through and answer each of the questions.https://markets.ft.com/data/funds/us https://money.usnews.com/funds/mutual-funds https://finance.yahoo.com/mutualfunds

I’ve put the intructions in a picture file next to my assignment. I need help to solve this. Everything is in the intructionss below