Lawrence Dignan

  • Here is the exercise.

    Here is the excel spreadsheet you will need to complete this exercise [In-Class Exercise 11.2 – NCAA 2013-2014 Player Stats]

     

  • Leave your response as a comment on this post by the beginning of class on April 10, 2017.

    Leave a post about your group project:

    What is the subject of your group project?
    Which of your fellow […]

    • Our group project will consist of the analysis of smartphone ownership (Pew Research) worldwide through the manipulation of survey data. We will leverage excel, SPSS, and Tableau for data manpulation and visualization. My group mates are Craig Stetchak, Phillip Aaron, Izzy Sarlo, and Anthony Petrole.

    • Our group will consist of Fei Qing, Yaning Wang, Yixuan Zhou, and Man Shu Wong. We will be analyzing the 2016 presidential campaign fundraising. Our data source will download from the federal election commission, the goal of the assignment is to examine the financial strategy being used during the campaign by using data analysis tools such as Excel and Tableau.

    • Our group is myself, Patrick Granquist, George Raymond and Jillian Foster. We do not have a idea yet but we will after this class period.

      • Our group will be analyzing who has healthcare in the US. We will examine the data and make a heatmap of the country to show where the highest concentration of insured/uninsured Americans live.

    • Group Member: Imani West, Alex Fortebuono, Daishaun Grimes, Sai Gangisetty & Ben Bucceri

      We will be analyzing the upcoming NFL Draft based on the statistics provided by the 2017 NFL Combine.

    • Subject: home court advantage in college basketball – is the home team more likely to win? Does playing at home significantly affect offensive or defensive statistics of either team?
      Group: Ben Bucceri, Sai Gangisetty, Daishaun Grimes, Alex Fortebuono, Imani West

  • Leave your response as a comment on this post by the beginning of class on April 10, 2017. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your o […]

    • I usually wonder what happens to the airplane waste and how much does it weigh. According to the article, airlines passengers generated 5.2m tones of waste in 2016. This is a significant amount of waste and it bothers me because I am a person who travels a lot, and I consider myself to be among those people who contributes airlines waste. The article states that the waste contains the toilet waste, wine bottles, half-eaten lunch trays, unused toothbrushes, and etc. I felt worse after hearing that because i thought the food I did not touch would be recycled at least, not knowing they threw them away. Also, the article states this costs this industry $500M per year, which is also a significant amount of money that can be reduced and add toward ticket costs. I am hoping they solve this issue and have their products be recycled instead of being thrown away unused so probably can lower air fair for everyone.
      https://www.theguardian.com/sustainable-business/2017/apr/01/airline-food-waste-landfill-incineration-airports-recycling-iberia-qantas-united-virgin

    • Cybersecurity has become an increasingly prevalent problem in the past couple years, especially in an increasingly digitized society. Even still, Americans are still a little unsure of cybersecurity topics. For instance, only only 54% of surveyed Americans are able to correctly identify a phishing attack, which could give up personal data. Additionally, only 46% understood that email is not encrypted by default, and 39% of users are “aware that internet service providers (ISPs) are able to see the sites their customers are visiting while utilizing the ‘private browsing mode.'” From a basic standpoint, adults are less likely to identify a secure password from a list, making their accounts even more vulnerable. With the vast amount of data on the internet and in the cloud, etc., this really poses a problem for our future security.

    • My article explains how analytics have taken over the game of basketball and now are relied on way too much. Recently in the last 5-7 years, NBA GM’s and scouts have started using advanced statistical analyses on potential draft prospects to try and predict if they will pan out and be a contributor to their team or not. Mark Cuban is a notable owner and businessman and he talks about how analytics are soon going to be inferior to AI. https://www.si.com/tech-media/2017/03/31/mark-cuban-analytics-overrated-technology-sports

    • A few surprises in the data behind single-sport and multisport athletes

      I found this article quite interesting because my brother is actually going though the process of selecting colleges and he is an athlete. He is a soccer player, however, he was a multi sport athlete for most of his life until high school. My mom wanted to be a multi sport to appeal to college scouts more, but the data from this article proves that soccer is often a single sport commitment. I think sports such as soccer and gymnastics have more single sport athletes because they can be competed year round. Football and lacrosse are seasonal sports, so it is often encouraged that participants of these sports participate in another sport in their “off season” to stay in shape.

    • https://www.forwardgeek.com/article/Dtex-April-Insider-Threat-Alert-Tax-Season-May-Lead-to-Increased-Employee-Driven-Data-Breaches-Privacy-Violations-20170406

      Ths article deals with how cybercriminals look to tax time and data obtainable on LinkedIn and Facebook to get information on employees. By getting information easily obtainable on the internet such as employer, position and 401ks from companies that post them online, cybercriminals are targeting company HR leaders, calling to get information such as social security number, salary amount, etc. They can then use this information to steal the employees identity and obtain credit in their name. HR people need to be more cautious of who they give information to; just because someone identifies themselves as an HR leader doesn’t mean they are being honest.

    • https://www.theguardian.com/technology/2017/apr/08/speed-reading-apps-can-you-really-read-novel-in-your-lunch-hour
      This article talks about the history of speed reading and how it has become a popular thing. In the article, it listed some presidents that used to practice speed reading, and some popular ones are: President Kennedy, Nixon and Carter. The article are show some an example of a resource to help with speed reader. However, it comes at the cost of $4.99 and it is an application that uses RSVP (Rapid Serial Visual Presentation) to help increasingly feed text to the user. And lastly, the article found that attempting to read over 600 words per minute will lower the comprehension rate to below 75%. This article was interesting to me because as a college student, I tend to try and speed read my readings. That may not be good because it might lower my comprehension rate of the reading.

    • https://fivethirtyeight.com/features/one-slow-month-doesnt-change-the-strong-trend-on-jobs/
      This article is about jobs in the US. The US added 98,000 jobs in March, per the Bureau of Labor Statistics. This is a sharp decline from February, and the figure falls far below most economists’ expectations. This article, however, reassures us that one slow month of job growth doesn’t change the fact that for a long time, job creation in the US has been very strong. In fact, the unemployment rate currently sits at about 4.5%, which is the lowest it has been in over a decade. Additionally, the labor force participation rate increased. Hourly earning have increased since 2012 as well. Overall, despite a slow month in job creation, the US labor market is as strong as its been in a very long time. It was interesting to me because a lot of people I know were troubled by March’s numbers, but this article reassured us that the labor market is doing just fine.

    • http://www.tomsitpro.com/articles/oracle-big-data-cloud-services,1-2981.html
      I found this article quite interesting because I just did a research on Amazon Redshift a while ago. It is a data warehouse like Oracle. As a competitor of Redshift, Oracle offers some new features such as combine SQL and NoSQL together, enhanced Natural Language Processing, etc which can reduce the amount of time spent preparing data for analysis.

    • http://www.nbc12.com/story/35113409/gamestop-investigates-possible-data-breach

      This article details a recent data breach suffered by GameStop, a video game retailer. The company’s website was hacked and the credit card information of its customers was believed to be put up for sale on a website. The article discusses the different ways you can protect and monitor your financial data in the chance that your data was involved in the hack.

    • http://www.mastersindatascience.org/industry/health-care/
      This article talks about data in the health care industry. Even though I am a business major, the health care industry has always been once of my main interests. There is always new and upcoming data in health care, and it is really important because it can impact peoples lives immensely. This article talks about prices, medicines, new devices and more, that could impact the industry.

    • https://fivethirtyeight.com/features/one-slow-month-doesnt-change-the-strong-trend-on-jobs/
      This article talked about the slowdown in U.S. job increasing rate in March, which is out of expectations. However, the author explained that there was no need to worry too much about these data, and the author listed some possible reasons about this slowdown, such as weather, and change in unemployment rate.

  • Hadoop for non-geeks

    A note about that first reading: It’s a bit dated and Hadoop has advanced since that article. Much of the focus in the open source community has been on side projects tied to Hadoop. […]

  • This NYT article on how Google researched teams and their effectiveness is worth a read.

  • Here is the study guide for the second exam. Nathan will hold exam review at 8:30 am – 10:00 am on Friday (03/31/2017) at Breakout room Alter 236C

  • Here are the assignment instructions.  Groups MUST be 4 to 5 members.  You may not do this assignment on your own or in smaller groups than 5. Note that the date on the assignment is incorrect.

    The as […]

  • Here is the exercise.

    And here is the Excel workbook you’ll need [Pew Story Data (Jan – May 2012).xlsx]

     

     

  • Some quick instructions:

    You must complete the quiz by the start of class on March 27, 2017.
    When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign […]

  • Here is the exercise.

    And here are the workbooks [2012 Presidential Election Results by District.xlsx and Portrait 113th Congress.xlsx]

  • Data integration

    GOP Analytics

    Dashboard best practices

    The One Skill You Really Need

  • An interesting read on how Foursquare is building its dashboards and analytics out for retail. Worth checking out.

     

     

  • Leave your response as a comment on this post by the beginning of class on March 27, 2017. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your o […]

    • Grade Point Average (GPA) is an example of a KPI for students to see how well they are performing in school. It is specific and measurable, as it is on a 4.0 scale, and each class (depending on the credits) factors into the score. It is achievable, as students can increase or decrease their scores by doing better or worse in class. It is relevant, since having a higher GPA causes the student to have more chances to get a scholarship or job opportunities. And it is time-variant since a student’s GPA will change each time a teacher enters new grades (by semester or class schedule).

    • An example of a KPI is the Virtual Wallet app for PNC which tells me my account balance.
      Specific and Measurable: It tells me the precise amount of money I have in my account
      Achievable: I can deposit more money for a specific goal.
      Relevant: It determines whether or not I can withdraw money and whether or not I should deposit money if there isn’t enough funds.
      Time-variant: I can look at my balance over days, weeks, etc.

    • My fit bit telling me the number of steps I do in a dap is KPI. Steps are specific and measurable because it is a precise measure of the number of steps I took. It is achievable because I can set my goal for the number of steps I want to take in a day and it will vibrate once I achieve my goal. It’s relevant because number of steps taken in a day can be compared to how active or fit I was that day.

    • MyFitnessPal is an app I use to count daily calories.
      Specific purpose – to ensure I meet standard calorie goals for the day
      Measurable – uses exact calories for counting
      Achievable – I have a specific caloric intake goal for the day
      Relevant – it keeps my focused/on track with greater health goals
      Time Phased – it’s a daily process.

    • A KPI that is incorporated into my lifestyle are the metrics displayed on a treadmill at the gym, specifically distance, time, and calories burned. These are measureable becasue each can be represented as a numeric digit (ex. 0.09 miles traveled, 2:20 minutes of use, and 230 calories burned so far). The metrics are achievable because i can alter my pace to return metics more suitable to my workout plan. The metrics are relevant because distance is directly related to treadmill use since users care to know how far they have ran/jogged/walked to measure exercise milestones and use a uniform measurement for visiting other gyms and using different machines. Lastly, the metrics are time based because health improvements are a daily process and correlate to frequency and severity of exercising.

    • My alarm clockis an example of a KPI. It’s specific and measurable because I can set spcific alarm time, like seven hours later. It is achievable because it rings at designed time points. It’s relevant it determines my sleeping time. It’s time-variant because the alarm time in weekends is later than in weekdays.

    • An example of a KPI that I use is called sleep cycle. It is specific and measurable because it measures the exact amount of time that I sleep and it wakes you up after you finish cycles of rem sleep. It is achievable because I can choose what time I want to sleep and what an approximate time that I would like to wake up. It is relevant because waking up during rem sleep will make you wake up groggy. And it is time-variant because you it logs the amount of sleep you get.

    • The pedometer on my phone that I use through the app My Fitness Pal is an example of a KPI to see how many steps I have taken over a period of time. It is specific and measurable because you can set your goal as the standard 10,000 steps or increase it based on how active your lifestyle is. It is achievable because people should walk on average 10,00 steps per day, but a person can increase the amount of walking they are doing to meet their goal. It is relevant because the amount of physical activity a person does can affect their health in a positive or negative manner. It is also time variant because you can look it over daily, weekly, or monthly.

    • A key performance indicator used by all students is the Grade Point Average. This is a great example of a KPI because he GPA covers all of the SMART criteria:
      Specific- a broad spectrum to valuate an individual’s grades
      Measurable- distinct metrics to approximate one’s grades overall
      Achievable- depicts where you score and clearly defines goals
      Relevant- stays up to date and summarizes your overall grades
      Time Phased- changes every semester

    • My phone telling me how much power in the battery I have left is a form of KPI I use on a regular basis. The color and image of the battery icon is specific and measurable. Charging my phone for more battery life would be achievable. Lastly, It’s relevant to how much use I can get out my phone in a specific timeframe.

    • A form of KPI that I use on a regular basis is the Dow Jones Industrial Average (DJIA). It has a Specific purpose of averaging a number of stocks and consolidating that into a single amount. The DJIA is measurable, as it is a number that measures the average performance of the top companies in our economy. It is achievable, as the it has a start amount and is measured based off of that each day. It is relevant to the success of our economy, though it is an average so it doesn’t necessarily measure each company, but a multitude of them. It fluctuates exponentially during market operating hours.

    • An example of a KPI I use in my daily life is grades in my class. depending on my performance I receive a grade out of 100. I can use that measurement to gauge how well I am performing in a class. This KPI lasts until the end of the class, it is achievable and a measure of success.

    • I think a cool KPI to talk about is within the sports industry. Scouts are constantly trying to identify key performance indicators to evaluate players. In basketball for example, metrics like points, assists, rebounds, turnovers, shooting percentages, and minutes are all KPIs to evaluate how well a player is performing.

    • Probably the most common KPI we interact with while in college is our GPA. Our grade point average measures our academic performance in class. It is specific because it is specific and measurable as it takes the averages of the grades earned in your class. It is achievable because you can make improvements to your studying habits to improve your GPA. And it is relevant because it measures how well you performed in class and you can compare it against other students GPAs.

    • Checking you credit or bank account has been the most convenience way people can access either their account or credit scores. I personal like to check my credit score through the various app that I have. It is not something that I use most often, but I go on there to see how I am doing. There are many factors that go into how the credit score is formed and they can be considered as the KPIs. According to the SMART criteria, Specific, Measurable, Relevant and Time-bound would relate to the KPI that form the credit score. Specific because the score lets you know where you stand on the scale, Measurable because they provide you the score every month, Relevant because credit scores are important to know since based on the score, you can tell if you are doing well or not and Time bound since the score changes every month.

    • I started a business and I am focusing on increasing traffic to my website. I built my website, setup my social media platforms and created a YouTube channel to provide content to my targeted audience. Now that I setup these online channels I want to track how the market responds to each action or post. The goal is to convert page views into new clients and this is specific, measurable, relevant and actionable. The time frame has not be identified because I would like to have an increase in clients today. This takes time and work on my part to improve SEO rankings and capture more awareness. I have been able to reach a few hundred page views that I have been tracking with google analytics. I will double my page views by April 26, 2017 and convert 10% of those views into a phone call, email or face to face meeting. Of this 10%, I will convert 10% of those interaction into new clients contracts.

    • A KPI that I use frequently is the steps tracker on my iPhone. It is a SMART KPI because

      S: It is specific because I set a goal I want to accomplish for the week. If I fall short of it, I fail, if I reach or exceed it, I succeed.
      M: It is measurable because the pedometer counts the total # of steps I take and breaks it up into days/weeks.
      A: It is achievable because I gradually increase my steps goal and adjust it to how busy my weeks are, but always have a baseline I do not want to go below to make sure I am moving around
      R: It’s relevant because I want to make sure I don’t live a sedentary life, especially when I am busy. A pedometer gives me an accurate gauge of this.
      T: It’s time-specific because I measure success on a weekly basis.

    • A KPI that is used by me nearly every day is my GPA. It is both specific and measurable as It is has a scale which can go up to 4.0 and all of my performance in classes factor into it. The GPA is achievable because my individual achievements in class decide what it becomes. It is relevant as it is used by the university to judge my progress in classes and whether or not I am achieving the grades I need to. And it is time sensitive as it changes with each grade that is entered into the gradebook.

    • One common KPI that we use is grades. It is a SMART KPI because
      S: it is specific because for each letter grades, it has specific requirements.
      M: It is measurable because for each letter grade it has a number range.
      A: It is achievable because I can get different letter grades depending my behavior in the class and exams.
      R: It is relevant because it may affect my GPA and further will affect my application for a job or graduate school.
      T: It is time-specific because it is measured in a semester basis.

    • A KPI that I use on a regular basis is treadmill. It is specific because I put it at a specific speed and then it measures the distance, time and amount of calories while I am running/walking. It is achievable because I set a goal for myself to go a certain distance in a certain amount of time. It is relevant because it helps me stay healthy and fit. It is time-phased because it depends how many times a week I use the treadmill and how long I spend on it.

    • The amount of invoices I process in a certain work period is a good KPI
      Specific – Many invoices are similar and therefore it is a specific task
      Measurable – A simple numerical count of invoices processed
      Achievable – I have a number in my head (about 15 invoices an hour) that I can reach
      Relevant – Since I work in accounts payable it is vital that the invoices get input and processed in a speedy and accurate fashion
      Time – The quicker I process invoices the quicker we can pay vendors and perhaps get discounts on our purchases

    • One example of a KPI is a Grade Point Average (GPA)
      S: it s specific because there are certain requirements for lettered grades
      M: this is measurable because it tracks a student’s grades in all of their classes
      A: this is achievable because not every student will have the same GPA
      R: this is relevant because it can affect a person’s future job prospects
      T: this has do with time because it measured over a person’s whole college career

    • A KPI that I use is my GPA. This is a reasonable one because it is standardized for the whole business school so it is a basic guideline for performance. It is available and achievable for everyone so it adds on to the factor of basic guidelines. My GPA has time concept applicable to it because it is specific to each semester as well as the whole four years itself. And finally it can be measured with numerical values and have various distributions.

    • Even though this seems to be the general topic of discussion in this weekly question, GPA is an obvious KPI as it is easily measured through assignments. Its very specific because it breaks things downs through percentages.

  • Here is the exercise.

    And here is the spreadsheet to complete the exercise [In-Class Exercise 8.2 – OnTime Airline Stats [Jan 2014].xlsx].

  • Leave your response as a comment on this post by the beginning of class on March 9, 2017. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your o […]

    • I have not been in the position to make one of those mistakes so I think the most important one to avoid is Number 3: Start working on the database without doing a full backup first. If there is saved backup then if something goes wrong there is a least a backup you can rely on. That way you do not lost something that you or others have put in hours of work on. It may take an extra minute or so to do it but its better to be safe than sorry.

    • The most common mistake that I make when manipulating data AND the most important mistake to avoid in my opinion is to back up data. On many occassions i have forgotten to back my data up and corrupted the file due to incorrect manipulations, then I would have to restart from square one when i could have backed up each step of the way to save time and precious insights. Backing up is a must every step of the way, especially when the data contains vulnerable data or if the data does not belong to you. Like Anthony said up top, better safe then sorry. Only takes a minute so make this step instinctual.

    • Fortunately, I have never had the opportunity to make these kinds of mistakes while working with data. However, I think the most important mistake to avoid is Number 1: Click “yes” without carefully evaluating the message that says “do you want to remove this from the server?.” Although not with data, I have clicked “yes” on dialogue boxes that pop-up on other sites without reading what it says, and it has caused major problems — deleting files, closing servers, etc. Without reading the message properly, files may become corrupted, or altogether destroyed. Taking a bit more time in the short-run, and being careful, will save a lot of time and effort in the long-run. As Ben Franklin was fond of saying, “Haste makes waste.”

    • I have accidentally sorted the data in an excel file and not included all of the columns. Luckily I noticed soon enough that I could use the back arrow to correct my mistake. Doing something like this is really easy to do when your quickly clicking around, so I always make a back up file.

    • I’ve never made any of the mentioned mistakes, but I think the most important to avoid is #6, missing the data type. This one seems to be the trickiest. You could make an entire spreadsheet, thousand of rows and columns deep, and everything seems fine, but using the wrong data type for just one cell could ruin the whole sheet. For example, using string when it is meant to be date/time.

    • Sometimes I will forget to check the data type, and it is hard to find out what is wrong with the data. So I think it is important to avoid #6, Missing the data type. Especially with dates and integers. Because it is hard to tell the difference and it can ruin the whole data.

    • I have forgotten the data type before, and nothing happened-no data would sum! It was very annoying and it took a great deal of time to figure out. I would argue, however, that keeping a clean backup at all times is the most important thing, because if you don’t have a lot of time to dedicate to this issue, at least you can start at the beginning. Sometimes redoing it will reveal to you what you did wrong the first time.

    • I haven’t made these mistakes, and I think the third mistake “start working on the database without doing a full backup first” is the most important to avoid. If you made some mistakes other than the third one, you could waste some time to fix the problem, but if you started working on the database without doing a full backup, the mistake might cause irreparable loss, and you might not be able to start over again.

    • I have done Number 10, “Open a CSV file directly into Excel”, many times without even knowing it could cause problems. I suppose in those prior situations the data I was working with wasn’t large enough where scientific notation kicked in, but it is good to know this tip to avoid in the future.

    • I have often opened a CSV file into Excel, I was not even aware that doing so could cause serious problems. Since my past experience with excel has mostly just been using it for small in class assignments I guess there was not much that could have gone wrong. Going forward I will need to be more careful about how this could affect my data.

    • I have used Excel many times, but I have been lucky to not have experienced any of these mistakes. I think the most important to avoid is Number 3: Start working on the database without doing a full backup first. If you forget to back up your work before using it, you risk losing it. You also have to be careful if you mess up because if it is not backed up, you might not be able to start over.

    • A common mistake I have made in the past is to not back up the data that I was working with, and at times create different versions. This has particularly happened to me on excel sheets for finance classes, such as intermediate corporate finance, in which I would work on a pro forma without saving my progress at various stages. That way, if I made a mistake after a certain stage, I could access the last stage and begin from there.

    • Step number 3 is the most important step. Step number 3 is to start working on the database without doing a full backup first. Having a full backup is always important because if something happens where the file doesn’t save, you will still have the file available to you. Although this never happened to me with an excel file, it has happened to me on word and I had to start the file over again because I did not make a backup of the file.

    • I have not made any of these mistakes before but I believe that #6 would have the most impact since it is quite tricky to catch when dates are integers or integers have dates when you have a huge data set. You would have to implement clearly defined columns and know the data that you are working with very well in order to avoid this type of mistake.

    • A very common mistake I have made before is number 3: start working on the database without doing a full backup. Often I start work right after receiving the job, and I always assume autosave would save any accident happen when working on the database. However, sometimes the system does not save all of the data you have, and in order to ensure you don not lose your data you have to fully backup the database as well as do checkpoint save along the way!

    • I do not have much experience working with such data mentioned in the article, therefore, I have not made one of the mistakes mentioned. However, I believe the worst mistake would be to not backup your workbook before making edits to it. If you make a monumental mistake in the beginning and don’t realize it until later, all of your work will be compromised because you didn’t save it. Backing up your work is probably the biggest mistake you can make, whether you are working on something relating to data or not.

    • I have not made any of these mistakes, but I think the most important one to avoid would be working on a database without a full backup. Without running constant backups, you can run the risk of losing hours of work. Not backing up a database can also cause it to be out of date with relevant information because it has not been backed up recently.

    • Of the common mistakes made in Excel, the most common one I have committed is number 9: copy formulas that use relative formulas. Though I do not use Excel that frequently, this is the problem that I run into the most. This problem occurs when I try to copy a formula in another cell and it doesn’t produce an actual value, instead it gives an error in the cell or group of cells. I often forget to use absolute formulas and have to go back after the error message occurs, or it gives a number that isn’t close to what I’m attempting to calculate.

    • For number 3, I’ve done this a lot in the pre-autosave days. If I’m in a rush the last thing I will think about doing is setting up a backup to a database I’m working on. If it’s not a personal database, I can’t see anyone making this mistake. It’s just too risky not backing up all the data that’s being changed.

    • Luckily I have never made any of the mistakes listed in the article, but I think the most serious mistake is #3, doing work without a full backup. I’ve never had this error occur with data, but with basic assignments using powerpoint and word there have been times thatI haven’t saved a file only for my computer to shut down or for me to exit out of the tab accidentally, ultimately losing everything I’d spent hours working on. While most of the mistakes have some solution or clean up that may be enacted following the time the incident occurred, losing material without doing a backup is essentially hitting the restart button on any work you’ve put work and effort into accomplishing.

    • A few semesters ago, I took digital analytics which is a required course for advertising majors on the account management and media planning track. Within the class we worked closely with excel and Google Ad Words. I found committing a few of the errors mentioned in the article. One that i would commit constantly was copying the wrong formulas, in return i would get the wrong values. I’ve also accidentally delete some of my data multiple times and either did not notice until it was too late or picked up on it and had to start all over.

    • I have been doing a lot of work with Excel over the past month and I have found that it is easy to make mistakes. The problem is that if you do not go over your work with someone else you may not always see the errors. I think that it is important to explain your analysis to another person in simple language. I have been using COUNTIFS, SUMIFS, VLOOKUPS AND IFS functions. This are so awesome and can be confusing when you over thing them. A specific change that I have had is when I want to count groups that match a specific criteria it can be ease to over look or click on an adjacent cell. This was a lesson I had to learn. My solutions is ; I do the analysis, sit the project down and then I explain it to another person to help give me clarity while checking my work.

    • I think the most important error to avoid is simply reading what questions ask instead of just hitting yes. Too many times people are trying to figure out how to do something and just hit yes or allow without reading what they are doing. This can lead to inaccurate calculations and can mess up your data. It is very easy to take the time and read what pop ups say.

    • Working on something without creating a backup is one of the worst things you can do. There are so many factors that can play into something like that going wrong. its best to always create a backup.

  • Some quick instructions:

    You must complete the quiz by the start of class on March 20, 2017.
    When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to […]

  • Performance indicators

    Tyranny of success: Non profits and metrics

    Tracking health

    Wearable tech

  • Here is the exercise.

    And here is the dataset you’ll need [Vandelay Orders by Zipcode.xlsx].

  • Load More
Skip to toolbar