Data Science Stack Exchange
Data Science Stack Exchange

Questions tagged [excel]

Excel is a spreadsheet based software, for numerical input, developed by Microsoft and part of the broader set of the Microsoft Office Suite.

Excel is a spreadsheet based software, for numerical input, developed by Microsoft and part of the broader set of the Microsoft Office Suite. It can be used to carry out various spread sheet related tasks including data calculations, regressions, visualization, and macro programming. It also supports the Visual Basic for Programing (VBA) programing language for more sophisticated development.

80 questions
42
votes
10 answers

Do data scientists use Excel?

I would consider myself a journeyman data scientist. Like most (I think), I made my first charts and did my first aggregations in high school and college, using Excel. As I went through college, grad school and ~7 years of work experience, I…
JHowIX
  • 523
  • 1
  • 4
  • 6
13
votes
4 answers

How to Write Multiple Data Frames in an Excel Sheet

I have multiple data frames with same column names. I want to write them together to an excel sheet stacked vertically on top of each other. And between each, there will be a text occupying a row. This is what I have in mind. I tried the…
Della
  • 315
  • 1
  • 3
  • 9
11
votes
6 answers

Is Excel sufficient for data science?

I'm in the process of preparing to teach an introductory course on data science using the R programming language. My audience is undergraduate students majoring in business subjects. A typical business undergrad does not have any computer…
I Like to Code
  • 267
  • 2
  • 5
8
votes
1 answer

How far can one go with excel?

in my business we handle all analytics through Excel. This includes mostly scheduling, production planning and accounting operations. We currently are looking into adding a bit of predictive modelling and Excel does suffice to a point, but doesn't…
Jcart
  • 340
  • 1
  • 6
4
votes
3 answers

How to predict whether or not a customer will renew

I have a dataset of customer contracts that specify a start date and if applicable an end date. Each month a customer is up for renewal. Below is an example of how the data is organized in excel: ID Customer Start Date Customer Drop Date 1 …
Geometric
  • 41
  • 2
4
votes
1 answer

How to generate bulk graphics using R

I have a dataset of Key Performance Indicator (KPI) and for each KPI I have a current level of achivement and 2 targets : Target1 and Target2. How can I automatically generate one graphic for each achievement as in the file attached here. As I have…
Samy Koffi
  • 55
  • 5
4
votes
1 answer

How to interpret standard deviation calculated by excel

I have some percentage values in my excel spreadsheet like: When i use the STDEV function to calculate the standard deviation with these values, i get 0,125. How should i interpret this? Is it +- 0,125% or +-12,50%?
heresthebuzz
  • 395
  • 3
  • 9
3
votes
2 answers

Pandas datetime error when reading from excel file

I am trying to read an excel file that has two columns using pandas. This is how the data looks in excel file: DT Values 2019-11-11 10:00 28.9 2019-11-11 10:01 56.25 2019-11-11 10:02 2.45 2019-11-11 10:03 …
Uday T
  • 322
  • 1
  • 5
  • 11
3
votes
2 answers

Expectations of the skill set of a Data Scientist

Although there are more powerful tools than Excel which a data scientist should know how to use, would it be expected that someone indicating they are a Data Scientist know how to use Excel?
Lisa
  • 31
  • 1
3
votes
1 answer

logistic regression coefs to excel formulation

I have done a Logistic regression in r with 3 variables involving 1 interation: lm(predicthead~vol+weekday*head, mydata) weekday is a factor - 7 days of the week. The coef values are : Estimate (Intercept) -14.81119721 Vol 0.118819705 weekday2 …
surpavan
  • 145
  • 6
3
votes
3 answers

Giving each person in order their top choice which is still available in Google Sheets

The problem I want to solve is my residential building's garage choices. There will be a random distribution of parking spaces. I thought that it would be better if each person writes down which spaces they want in order of preference, and then…
Heleno Paiva
  • 131
  • 3
2
votes
1 answer

Cleaning data with two fields mixed in the same column?

I am working on a template for a dashboard that is giving me some serious trouble. The format the data comes in is highly unstructured. In the image below, circled items are "Site Names", data is Month-level. The issue is that the "Site Names" are…
SchrodingersStat
  • 165
  • 5
2
votes
1 answer

Working with text files in Excel

I have an excel file containing a long text in column A. I am looking for the words starting by "popul" such as popular and populate . I can find these cells by the formula: =SEARCH("popul",A1,1) I want a function that returns the whole words…
Hamideh
  • 920
  • 2
  • 11
  • 22
2
votes
0 answers

Tools for reading data from large, irregular csv files (aka excel file hell)

I have a csv file with 1000 columns and 50 rows that was collected over a few months. Embedded randomly in the file are ~1000 small datasets with semi-standard formats (some columns differ, so does number of rows). There are also identifying…
R Greg Stacey
  • 141
  • 4
2
votes
1 answer

Adding Group Average Line to Bar Chart

I am trying to create a PivotChart in the form of a bar chart and I would like to add a group average line on the chart. I have this (sample) table in my PowerPivot Data Model: Group averages are A: 20, B: 50 and C: 80. My bar chart looks like…
dreamerboy
  • 23
  • 3
1
2 3 4 5 6