Excel Expert for Operational Analytics Task
£20-250 GBP
Dibayar saat pengiriman
1.
Construct a queueing model that replicates a week of collecting and processing DNA samples.
a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database.
b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed.
c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system.
d. Use relevant notation and write out equations using Equation Editor in Word.
e. Note – the rule of thumb is that any reader can pick up your report and replicate your
results by following the methods.
2.
Use mean values of each parameter to construct an “average” solution.
a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled
individually.
b. Assume both CSI and forensics lab operations work 24/7.
c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis.
d. The unit of time to use in the model is minutes.
e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge
are filled with samples.
f. You MUST use Excel to model the process.
g. You MUST create, develop and save all your work in one file saved on your OneDrive
account. There are no exceptions to this. See Saving and Sharing instructions.
3.
Results to find from your “average” model solution:
a. To the nearest ten, how many samples will be processed by the end of the seven days?
How many of those samples will result in a DNA match?
b. What is the mean time to process a sample?
c. What percentage of samples meet the police force’s ambition to process samples in less
than one day?
d. Is there any stage of the process that looks under-resourced? Why?
4.
Construct a simulation model using the information provided to you above, and your average model as the starting point.
a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually.
b. Each iteration of the simulation is one week of processing samples.
c. Use the same assumptions as for the Task 2 model.
d. You MUST use @RISK. Do NOT save raw simulation data in the file.
e. You must save all your work in one file saved on your OneDrive account. There are no
exceptions to this. See Saving and Sharing instructions on pages 10-12.
f. You will need to determine the appropriate probability distribution for each input. g. Run the model for 10,000 iterations.
h. Set the random number seed to the 5052.
4. Results to find for the simulation model:
a. Present all time units in minutes.
b. Summarise* the distribution for the mean time a sample waits in the queue for the: CSI to arrive; for sample preparation; for DNA sequencing; and finally for validation.
c. Comment on any observations/insights from the queueing time distributions you have plotted and summarised in Task 4a.
d. Summarise* the distribution for the mean number of samples processed, and the mean number of samples matched to the DNA database, in one week.
e. Plot and summarise the distribution for the mean time to process a sample.
f. Plot and summarise the distribution for the percentage of samples that are processed in
under 24 hours (each iteration being one week of sampling).
g. How confident are we that at least half of all samples in one week will be processed in 24 hours or less?
h. Conduct an appropriate Sensitivity Analysis that shows the main influence on the time it takes a sample to be processed.
i. Conduct any other relevant, ad-hoc analyses that you think will yield useful insights to help reduce the time to process samples further.
5. What-if Scenario modelling
a. Taking your further analyses from Tasks 4f and 4g as the basis for improving the model,
construct 2-3 plausible scenarios that will improve the confidence that at least half of all
samples from one week are processed in 24 hours or less.
b. Modify at least two stages of the model (these must be reasonably unique – do not copy
scenarios from others).
c. Rerun simulation model with the same random number seed and compare results to that produced in Task 4.
d. By plotting and comparing relevant probability distributions, explain how your modified scenario has reduced the time taken to process samples, and how it has impacted the likelihood of processing samples in under one day.
6. Insights and recommendations
a. In your report, provide a short summary of your insights and recommendations for how
to improve the Rapid DNA process that was trialled over the past few months.
*Appropriate metrics to summarise a distribution are either mean(5th percentile;95th percentile) or median(5th percentile;95th percentile), depending on the skewness of the distribution.
ID Proyek: #38026260
Tentang proyek
24 freelancer rata-rata menawar £105 untuk pekerjaan ini
Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto Lebih banyak
Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time Lebih banyak
Hi There, With 15 years of experience in data applications, and data analytics, I am confident that I am the Excel expert you need for this operational analytics task. I'm well aware of the significance of precision Lebih banyak
Hi There Sara M., Good morning! My name is Jane a skilled Statistician with skills including Statistics, Data Processing, Excel, Statistical Analysis and SPSS Statistics. I have over 5 years in tutoring data analysis Lebih banyak
Dear client, I extend a warm welcome and invite you to explore the best terms of service tailored to meet your needs on your project" Excel Expert for Operational Analytics Task". Feel free to engage in negotiations fo Lebih banyak
Hello As an Excel Expert I can do this task, I will develop a comprehensive queuing model to simulate the collection and processing of DNA samples over a week. Utilizing Excel, I'll construct a detailed flow diagram a Lebih banyak
Hello I understand your request that you’re demanding Excel Expert for Operational Analytics Task As a Professional Geeks, I can avail creative, proactive and high-tech solutions to your development needs. I have ex Lebih banyak
Hello Good morning, As an experienced freelancer with a strong background in Excel, Statistics, Data Processing, SPSS Statistics and Statistical Analysis, I am confident that I am the perfect fit for your project. Ho Lebih banyak
Hello Sir/MAM I am a skilled full stack developer. Having rich experience in Java , C++ , C , C# , Python , Eclipse , Sql , Mysql , .Net ,Oracle , Object Oriented Programming , Data Structure Lebih banyak
Having honed my skills over a decade, I believe I'm the 'Spreadsheet Superhero' you need for this project. My expertise with Excel and Statistics equips me to transform complex data into comprehensive insights, ensurin Lebih banyak
Hey, Good morning Sara M.! I can do this Excel Expert for Operational Analytics Task project immediately while maintaining quality. My skills in Statistics, Statistical Analysis, Data Processing, Excel and SPSS Stati Lebih banyak
Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. For Lebih banyak
Good day, Having worked for over five years in freelance writing and editing across different fields, I have the versatility to tackle almost any analytical task thrown my way. My background includes extensive experien Lebih banyak
Hey Sara M., I have carefully read through the project requirements for the Excel Expert for Operational Analytics Task. To begin, I will construct a queueing model that replicates a week of collecting and processing Lebih banyak
Greetings, I'm Benard, and I appreciate your consideration of my bid proposal. Drawing upon my proficiency in PowerBI, SQL, Azure, 3D, Laravel, C++, C#, PHP, Python, WordPress, Shopify, as well as iOS and Android app d Lebih banyak
I am the expertise on this work what do you need for the You gave me the opportunity i am giving you the proper result
Welcome to my Portfolio... I am "Subodh"... I have lot of years experience in Data Entry field. I worked for so many companies as freelancer.. Some Points to Choose me: * Available online for 24*7 for any queries and Lebih banyak
I am excited to apply for the DNA Sample Processing Project as outlined. With expertise in queueing theory and simulation modeling, I am equipped to develop and analyze the process efficiently. My proficiency in Excel Lebih banyak
