Looking for software recommendations

  • Thread starter Thread starter byee614
  • Start date Start date
  • Tags Tags
    Software
Click For Summary
SUMMARY

The discussion centers on finding software solutions for manipulating and analyzing a database of 22,000 MLB games stored in Excel. Users seek alternatives to Excel for faster calculations, graph plotting, and regression analysis. Recommendations include Matlab for mathematical computations and R for statistical analysis. While SQL databases can store the data, they are not optimized for complex calculations.

PREREQUISITES
  • Familiarity with Excel for data manipulation
  • Understanding of statistical analysis concepts
  • Basic knowledge of programming in R or Matlab
  • Awareness of SQL database structures
NEXT STEPS
  • Explore Matlab for advanced mathematical computations and graphing capabilities
  • Learn R for statistical analysis and data visualization techniques
  • Investigate SQL database integration with R for enhanced data handling
  • Research performance optimization techniques in Excel for large datasets
USEFUL FOR

Data analysts, statisticians, and anyone involved in sports analytics looking to optimize data manipulation and analysis processes.

byee614
Messages
9
Reaction score
0
I have a database in Excel of MLB games for the past 10 years. It's around 22,000 games. I am looking for a program that I can use to manipulate this data, filter/sort based on certain criteria, write formulas, plot graphs, calculate regression lines, etc. I want to be able to input a few pieces of data and have it spit out graphs, equations, and regression lines quickly.

I know Excel can do most of this but some of the calculations take a long time. I was hoping there would be a faster, more math oriented program. Would Matlab be good? My friend thought a database oriented system like SQL would work. Are there any other suggestions?
 
Physics news on Phys.org
A SQL database could store the information, but they're not geared toward that kind of calculation.

Maybe R?
 

Similar threads

Which software to use to create this graph?
  • · Replies 3 ·
Replies
3
Views
4K
MATLAB To what extent is the fit to experimental data good?
  • · Replies 12 ·
Replies
12
Views
4K
Mathematica Issues With Mathematica - AGAIN (Not Displaying Plots)
  • · Replies 5 ·
Replies
5
Views
3K
Analyzing Hysteresis Curve Fitting: Overfitting or Not?
  • · Replies 9 ·
Replies
9
Views
4K
Other Strategy for going from postdoc to software
  • · Replies 2 ·
Replies
2
Views
3K
Software for finding a best-fit ellipse ()?
  • · Replies 1 ·
Replies
1
Views
3K
Software for creating graphs for presentations
  • · Replies 3 ·
Replies
3
Views
3K
Find Software to Automate Recognition of 2D Graphs
  • · Replies 3 ·
Replies
3
Views
4K
MATLAB Working out an equation on MATLAB using co-ordinates
  • · Replies 7 ·
Replies
7
Views
2K
MHB Math note-taking software for fast notes during lectures?
  • · Replies 1 ·
Replies
1
Views
3K