ProcessTrends.Com
Home
Chart Gallery
Video Tutorials
Trend Analysis
Using R
Data Visualization
 Global Warming
Map Excel Data with Google Earth
Chart Doctor
Advanced Chart Techniques
Links
What's New
Downloads
  About      
 Search Site RSS
   04/4/2008 4:30 PM

 

Downloads

File Description Image
Bank to 45o    
Blood_pressure_trend.zip    
Box_plot_trend.zip    
Chart_DOY_trend_comparison.zip    
Chart_hyperinks.zip    
Chart_Interactive_dynamic_xls.zip    
Chart_min_max.zip    
Chart_missing_data.zip    
Chart_monthly_cycle_tmpl.zip    
Chart_mov_avg.zip    
Chart_trend_with_events.zip    
Charts_dot_plot.zip    
Charts_parallel_XY_trend.zip    
Chrt_doc_runway_chart.zip    
Chrt_doc_runway_chart_rev_2.zip    
Chrt_doc_sel_sh.zip    
Chrt_in_Cell.zip    
Chrt_size_align.zip    
Chrt_XY_trend_animation.zip    
CO2.zip    
CO2_consol_ML_Vol_Law.zip    
Dashboard_sheet_layout.zip    
DJIA Trend Chart Format    
Dyn_chart_plot_last_X_values.zip    
Energy_Stat_Charts_1.zip    
Eur_temp_stations.zip    
Excel_Regression_tools.zip    
Exhibit_Intro.zip Video - Introduction to MIT's Exhibit 2.0. Shows community crime map using Google Maps and interactive query ability.  
Fecal_imperv.zip    
GISS_global_temp_anomalies.zip    
Hor_panel_chart.zip    
Interactive_chart_check_box.zip    
Interactive_chart_check_box_xls.zip    
Inter_dyn_excel_charts_wmv.zip    
Interactive_Regression.zip    
Juice_line_chart.zip    
MapExcelData.zip    
Mo_cycle_chart_vba.zip Monthly cycle charts show trend data in series of monthly trend charts. This workbook includes VBA procedures to automatically generate a monthly cycle chart.
Multi_chart.zip    
N_Hem_GISS_Temp_anomalies.zip    
Op_room_schedule.xls    
Open_mind_snowmelt.zip    
Open_mind_swiss_temps_1.zip    
Open_mind_swiss_temps_cpa.zip    
Open_mind_temps.zip    
Panel_dot_plot.zip    
PDTK_overview_3_21_06.zip    
Process_Dashboard.zip    
Screen_dashboard.zip    
Sea_Level_N_Atlantic.zip    
Seg_piecewise_regr.zip Linear regression can be done with all the data or just parts (segments) of the data to see if there are abrupt changes in the relationship. The boundaries between the segments may be called breakpoints. This post shows how to prepare a two segment regression analysis of trend data. The downloadable workbook includes an interactive method and a Solver based method to find breakpoint.
Stacked_Trend_Chart_Trans_data.zip    
Stacked_trend_chrt.zip    
Trend_w_Change_pt_enso.zip This workbook shows how to add colored shapes to an XY chart to illustrate changes in categorical variables, like El Nino - La Nina in the NYT's example.
Temp_trend_Stockholm.zip    
Trellis Chart with Excel and R    
Trend_control_chart_basics.zip    
Vostok_temp_420_k_yrs.zip    
XY_step_chart_formattted_dates.zip